Hi,
I have 4 command buttons.
I would like to get what the caption is on each command button using a for next loop.
The command buttons are named Answer1, Answer2,Answer3,Answer4.
I was trying to use the below code but it won't work.
Any ideas on how I can achieve this?
I have 4 command buttons.
I would like to get what the caption is on each command button using a for next loop.
The command buttons are named Answer1, Answer2,Answer3,Answer4.
I was trying to use the below code but it won't work.
Code:
Dim Caption(1 to 4) As String
Dim Number As Integer
For Number = 1 to 4
Caption(Number)=Userform1.Answer(Number).Caption
Next Number
Any ideas on how I can achieve this?