Hi Experts
I have approximately 152 option buttions in 76 frames of a userform i.e. 2 optionbuttons in one frame and laid out as per the following example. I want to change the caption of all of them to what ever is sitting in range C14 to E89 of worksheet "Raj".
e.g. I want the following
In Frame1
Caption of OptionButton1 = C14
Caption of OptionButton2 = E14
.
In Frame2
Caption of OptionButton1 = C15
Caption of OptionButton2 = E15
.
.
In Frame76
Caption of OptionButton151 = C89
Caption of OptionButton152 = E89
By looking around I found the following code but it looks too complex for me and if someone can modify this to my needs and give me a brief explanation would really be app
one more thing my optionbutton are not renamed, they have the original name i.e. OptionButton1 and so on.![]()
Please Login or Register to view this content.
I do not want to make them invisible, if there is not text it should just be equal to "TBA".
Regards
Raj
Bookmarks