LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
BG
 
Posts: n/a
Default Getting value of Option button

Hi

I put some option buttons (radio buttons) on an Excel worksheet and found it
hard to get the values of these buttons.
When using f.ex.

For Each S In ActiveSheet.Shapes
msgbox s.Name
Next S

I can see that all the buttons are on the sheet but I can't read tha value,
which is the mai goal to use option button.

Any help would be greatly appreciated.

Blind gate


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Option Button Help justaguyfromky Excel Worksheet Functions 2 September 5th 05 10:28 PM
Option Button Help justaguyfromky Excel Discussion (Misc queries) 1 September 5th 05 09:48 PM
Option Button Fable Excel Discussion (Misc queries) 1 August 16th 05 01:59 AM
selecting more than one option button Katie-Baughman Excel Discussion (Misc queries) 4 May 6th 05 02:24 PM
Second option button disappears when I make another column Monique Excel Worksheet Functions 0 March 9th 05 09:57 PM


All times are GMT +1. The time now is 12:20 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"