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?
 

Some videos you may like

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
44,705
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
44,705
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,099,487
Messages
5,468,889
Members
406,619
Latest member
bilestones

This Week's Hot Topics

Top