Hello,
I have option buttons in my Excel spreadsheet (Macbook, Mojave, Excel for Mac 16.46)
Can someone tell me how I can check the value (True/False) of an option button in VBA?
I have tried : If Optionbutton1.Value = True Then ...
But I get the error: Run-time error '424': object required
Which seems to mean VBA is not getting access to the object 'Option Button 1'.
Any ideas ? Thanks.
Last edited by Colin_in_Belgium; 03-11-2021 at 03:38 AM.
You may need to replace the sheet reference if not the activesheet
Please Login or Register to view this content.
The option appears in the same worksheet, but I decided to try your idea anyway ...
This worked: If ActiveSheet.Shapes("Option Button 1").ControlFormat.Value = xlOn Then
Excellent. Many thanks Andy !
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks