Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 21
Default Controlling an Option Group in a User Form

Hi,
I have a User Form with 3 Option Buttons enclosed in a Frame. The Option
Buttons all have the GroupName = grpMeas. None of the controls are
overlapping. I want to be able to set the group value with a single command
maybe something like:

ufrmFSFShtControls.fraMeas = 2 'set the second opt btn true, first and
third false

OR

ufrmFSFShtControls.grpMeas = 2

I can't seem to figure out how to do this and it's a big problem because the
controlling the opt btns individually causes a huge mess in managing the
Change events of the controls. Thanks in advance for any help you can provide.

Best Regards,
Dean

Code Excerpt, How I dimensioned the controls
*****************************************
'dimension variables
Dim ctloptMeas(1 To 3) As Control

'instantiate the control variables
Set ctloptMeas(1) = ufrmFSFShtControls.optMeas1
Set ctloptMeas(2) = ufrmFSFShtControls.optMeas2
Set ctloptMeas(3) = ufrmFSFShtControls.optMeas3

*****************************************
Reply
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
User Form: Cannot Update Text Box Charles in Iraq Excel Discussion (Misc queries) 0 October 12th 06 07:53 AM
user form related TUNGANA KURMA RAJU Excel Discussion (Misc queries) 3 March 23rd 06 12:17 PM
Want to get user selections from a message box using option buttons Walt Excel Discussion (Misc queries) 1 November 4th 05 03:04 AM
user form static69 Excel Discussion (Misc queries) 1 February 6th 05 08:43 PM
Subtotal of Subtotal displays Grand Total in wrong row Thomas Born Excel Worksheet Functions 5 January 6th 05 01:46 PM


All times are GMT +1. The time now is 05:44 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"