Hi All:
I'm using userforms now (thanks everyone for the help and ideas and would like to have the text in a label (Label2) change as the user changes data on the form.
I.E.:
When the form opens, Label2 = "Welcome to my form".
After the user selects their name, Label2 = "Hello Dave, what would you like to do?"
I tried the following code to set the label text when the form opens:
Private Sub UserForm_Initialize()
Startup_Form.Label2.Caption = Worksheets("List").Range("A65").Value
End Sub
When this code fires I get "Runtime error 9: Subscript out of Range"
I'm using Rows A65-A75 (formated as text) to store data for the label.
Any thoughts on what I'm doing wrong, or is there a better way to do this?
Thanks
Dave
I'm using userforms now (thanks everyone for the help and ideas and would like to have the text in a label (Label2) change as the user changes data on the form.
I.E.:
When the form opens, Label2 = "Welcome to my form".
After the user selects their name, Label2 = "Hello Dave, what would you like to do?"
I tried the following code to set the label text when the form opens:
Private Sub UserForm_Initialize()
Startup_Form.Label2.Caption = Worksheets("List").Range("A65").Value
End Sub
When this code fires I get "Runtime error 9: Subscript out of Range"
I'm using Rows A65-A75 (formated as text) to store data for the label.
Any thoughts on what I'm doing wrong, or is there a better way to do this?
Thanks
Dave