Changing the Caption of an Option button in a userform using vba

Hi there

I don't know if this is possible, but can the caption of an option button be changed using vba?

I have 4 Option buttons, namely opt1, opt2, opt3 and optOther. In a named range, I have a list of hierarchical names such as:

David Sykes, Andrea Brown, Carl Davids, Petra Jones, Steven Prentice and Belinda Grant in that order.

When I open the userform, I would like to see the option button opt1 showing the caption "David Sykes", opt2 showing "Andrea Brown", opt3 showing "Carl Davids". optOther will keep the caption "Other", but underneath it is a combobox cboOther, which when the user clicks the "Other" option, populates the combobox with the remaining list of names not shown on the option buttons (in this example, it would show Steven Prentice and Belinda Grant. (btw all names are ficticious!)

Finally, I want to extract the initials of the names selected, so if Carl Davids is selected, it will return cd.

mmm... I suspect this is not possible, but any advice will be greatly appreciated!

Many thanks

Hello Andy

The first worked a treat. I really didn't think there was a way! Thanks for that.

Unfortunately the getting initials code threw up an error highlighting "m_GetInitials" and specifing error message "Sub or Function not defined"

What do you think could be the problem?

Sorry about the delayed response, Andy.

Works perfectly now! Very grateful for your help.

Cheers