| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
group/frames
Hi
I have a frame that has a number of option buttons in it. Is there any way I can set all these to false with one line of code, by referencing the frame? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
group/frames
Libby,
I don't believe this is possible. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "libby" wrote in message ... Hi I have a frame that has a number of option buttons in it. Is there any way I can set all these to false with one line of code, by referencing the frame? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
group/frames
You can, however, use a loop structure to reset all the option
buttons to false. Dim Ctrl As MSForms.Control For Each Ctrl In Me.Frame1.Controls If TypeOf Ctrl Is MSForms.OptionButton Then Ctrl.Value = False End If Next Ctrl -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Chip Pearson" wrote in message ... Libby, I don't believe this is possible. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "libby" wrote in message ... Hi I have a frame that has a number of option buttons in it. Is there any way I can set all these to false with one line of code, by referencing the frame? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I subtract time where hh:mm:ss:ff (frames = 30 frames/sec) | Excel Discussion (Misc queries) | |||
| Counting time-frames | Excel Discussion (Misc queries) | |||
| freezing frames | Excel Worksheet Functions | |||
| reference excel in frames? | Excel Programming | |||
| Forms and Frames | Excel Programming | |||
Linear Mode
