Hi there, first post and I hope I'll be clear.
In VBA, I know I can create a variable: Var01=sheets(name).range(name).value
Then use it: sheets(othername).range(Var01).value
Question: In my sub routine, I have a commandbutton, and I want to make its name variable. Possible? If yes, please, how?
Ex. CommandbuttonName=sheets(name).range(name).value
"CommandbuttonName".backcolor=(my color).
Thank in advance
Bookmarks