PDA

View Full Version : [SOLVED:] How to know form Option button name or number


hrzagi
03-29-2021, 05:32 AM
I have excell file with lots of form option buttons in different groups and for VBA coding I need to know their name or number "OptBtns(?)". With ActiveX Option buttons its easy to see name in properties but for form Option button I cant find how to see their name or order so I can reffer to them in VBA? Any solution?
rollis13
03-29-2021, 05:59 AM
Right click the button and see the name in top left box 'Name Box' (beside your Formula Box).
hrzagi
03-29-2021, 06:46 AM
Right click the button and see the name in top left box 'Name Box' (beside your Formula Box).
Right in front of my eyes :banghead: Thanx :thumb
rollis13
03-29-2021, 06:56 AM
Left eye :yes :rofl:.
Glad having been of some help :thumb.
snb
03-29-2021, 08:05 AM
Tab 'Home', option 'Find/Selct', option 'Selection Pane'.