I would like to be able to create an object name (from the values in other variables) which I can then use to reference the object. e.g.:-
varOptButNum = "24"
varOptBut = "OptionButton" & varOptButNum
I end up with varOptBut = OptionButton24
I then want to be able to set the value of OptionButton24 to True but I can not figure out how to do that.
I tried using
varOptBut.Value = True but that did not work. Anybody got any clues?
varOptButNum = "24"
varOptBut = "OptionButton" & varOptButNum
I end up with varOptBut = OptionButton24
I then want to be able to set the value of OptionButton24 to True but I can not figure out how to do that.
I tried using
varOptBut.Value = True but that did not work. Anybody got any clues?