Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Follow up on this
Tom O: Gave me this code from earlier today. However I still need some help on this. The code that he gave me works great but it does not clear the optionbuttons until the user clicks ok so they never see it. I need them to see it. So how do I make this happen on the "fly" If the checkbox is false then the optionbuttons should be false, null not checked. This of course is all in a userform. TIA and thanks again To
With Me.checkboxJ If Me.checkboxJL.value = True The strJL = "JL Me.Frame1.OptionButton1.Enabled = Tru Me.Frame1.OptionButton2.Enabled = Tru Els Me.Frame1.OptionButton1.Value = Fals Me.Frame1.OptionButton2.Value = Fals Me.Frame1.OptionButton1.Enabled = Fals Me.Frame1.OptionButton2.Enabled = Fals End I End Wit -- Regards Tom Ogilv I have checkboxJL if it is on it has a value of JL. I then have optionbuttons that are used also. If the checkbox is flase I want to mak sure that the user cannot click and turn on either one of the optionbuttons the optionsbuttons are within a frame. Currently right now the user coul turn on one of the option buttons weather the checkbox is true or false. Ho do you code to make this happen? TI With Me.checkboxJ If Me.checkboxJL.value = True The strJL = "JL Els Me.checkboxJL = Fals End I End Wit If obReqJL = True Then strJLtype = Require If obOptJL = True Then strJLtype = Optiona |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
A follow up Question | Excel Discussion (Misc queries) | |||
Flag for Follow Up | Excel Worksheet Functions | |||
Follow-up to the IF with OR function | Excel Worksheet Functions | |||
INDIRECT Follow On | Excel Discussion (Misc queries) | |||
follow hyperlink? | Excel Worksheet Functions |