Hello Community:
Trying to figure out how to have a Frame caption Change has the cell value in A10 changes. Right now I have a form that opens up on the initialize event and populates the frame caption with the cell value in A10.
The frame opens up with the Modal Property set to "false" so the user can make a different selection in the workbook and see the values change on the form as they click different cells (the frame caption being one of the values that needs to change, but it remains static at the value the form was initialized on.) Simple code below:
Laugh at me later, I'm just learning!
Thanks,
pt
Trying to figure out how to have a Frame caption Change has the cell value in A10 changes. Right now I have a form that opens up on the initialize event and populates the frame caption with the cell value in A10.
The frame opens up with the Modal Property set to "false" so the user can make a different selection in the workbook and see the values change on the form as they click different cells (the frame caption being one of the values that needs to change, but it remains static at the value the form was initialized on.) Simple code below:
Code:
Private Sub UserForm_Initialize()
Frame1.Caption = Worksheets("CONTROLS").Range("A10").Text
End Sub
Laugh at me later, I'm just learning!
Thanks,
pt