Consulting

Results 1 to 5 of 5

Thread: How to know form Option button name or number

  1. 03-29-2021, 05:32 AM #1
    hrzagi
    hrzagi is offline
    VBAX Regular
    Joined
    Jan 2021
    Posts
    65
    Location

    How to know form Option button name or number

    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?
    Reply With Quote Reply With Quote
  2. 03-29-2021, 05:59 AM #2
    rollis13
    rollis13 is offline
    VBAX Contributor rollis13's Avatar
    Joined
    Jun 2013
    Location
    Cordenons
    Posts
    146
    Location
    Right click the button and see the name in top left box 'Name Box' (beside your Formula Box).
    Reply With Quote Reply With Quote
  3. 03-29-2021, 06:46 AM #3
    hrzagi
    hrzagi is offline
    VBAX Regular
    Joined
    Jan 2021
    Posts
    65
    Location
    Quote Originally Posted by rollis13 View Post
    Right click the button and see the name in top left box 'Name Box' (beside your Formula Box).
    Right in front of my eyes Thanx
    Reply With Quote Reply With Quote
  4. 03-29-2021, 06:56 AM #4
    rollis13
    rollis13 is offline
    VBAX Contributor rollis13's Avatar
    Joined
    Jun 2013
    Location
    Cordenons
    Posts
    146
    Location
    Left eye .
    Glad having been of some help .
    Reply With Quote Reply With Quote
  5. 03-29-2021, 08:05 AM #5
    snb
    snb is offline
    Knowledge Base Approver VBAX Wizard
    Joined
    Apr 2012
    Posts
    5,645
    Tab 'Home', option 'Find/Selct', option 'Selection Pane'.
    more suggestions ...
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules