show different text in a text box depending on cell value
 

..Is it possible to automatically show different text in a text box depending
on different cell value. eg. if cell a1=6, text box would show "Correct", if
cell a1=7, text box would show "Incorrect" etc

show different text in a text box depending on cell value
 

Just test the value as normal

If Range("A1").Value = 6 Then
Textbox1.TExt = "Correct"
Else
Textbox1.TExt = "Incorrect"
End If

--

HTH

RP
(remove nothere from the email address if mailing direct)


"John Davies" wrote in message
...
.Is it possible to automatically show different text in a text box
depending
on different cell value. eg. if cell a1=6, text box would show "Correct",
if
cell a1=7, text box would show "Incorrect" etc