changing properties of command button

khatri milan

New Member
Joined
Nov 6, 2019
Messages
17
many sources mention that when i add a control button from form controls into worksheet and right click on it, there should be option for properties from which i could change font, color , name etc.. but unfortunately when i do right click only options i see are: cut, copy, edit text, grouping, order,assign micro and format control but no properties . Using edit test i can change button name but that name is not recognized in vba code so how can i make it work?
 

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
42,752
Office Version
365
Platform
Windows
Choose Format Control
 

khatri milan

New Member
Joined
Nov 6, 2019
Messages
17
there is a field called alternative text, can the name written here be used inside vba code, i think its just caption and not the name to be used in code.
 

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
42,752
Office Version
365
Platform
Windows
Select the button then in the 'Name Box' to the left of the formula bar you can give the button a new name.
 

Forum statistics

Threads
1,086,110
Messages
5,387,892
Members
402,086
Latest member
vlmedia

Some videos you may like

This Week's Hot Topics

Top