Hi - I'm a newbie here so please go easy on me
I am trying to write some code that will access the Caption property of an OptionButton called Q01. Easy -
sheet.q01.caption
but my problem is that 'Q01' is held in a cell (which could be q02, q03 etc). So if I have a range 'r' that contains this text, how do I refer to
sheet.(r.value).caption?
Thanks for any help
Phil
Bookmarks