but with a minor inconvenience. I can't get data I move from a worksheet to a userform text box to display in any color but gray. The font is correct, and it changes if I change the Font property in the Prpoerties area. I've set ForeColor there, and I've included the following statements before and after moving the data but none of these work:
LATA.ForeColor = 26
LATA.ForeColor = RGB(200, 0, 200).
I move the data with:
LATA.Value = Worksheets(1).Cells(ROWW, 2)
Any ideas how to get the data to display in color???
Also, is it necessary to unload a userform when quitting an application? I have a command button that's used to exit the app:
Private Sub QUITbtn_Click()
Unload CLLIsearch
Workbooks(1).Close SaveChanges:=False
End Sub
Thanks to all for your earlier responses. They've been very helpful.
Regards,
Bidwin
LATA.ForeColor = 26
LATA.ForeColor = RGB(200, 0, 200).
I move the data with:
LATA.Value = Worksheets(1).Cells(ROWW, 2)
Any ideas how to get the data to display in color???
Also, is it necessary to unload a userform when quitting an application? I have a command button that's used to exit the app:
Private Sub QUITbtn_Click()
Unload CLLIsearch
Workbooks(1).Close SaveChanges:=False
End Sub
Thanks to all for your earlier responses. They've been very helpful.
Regards,
Bidwin