Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Checkbox with OPtion buttons
With Me.checkboxJL
If Me.checkboxJL.value = True Then strJL = "JL" Me.Frame1.OptionButton1.Enabled = True Me.Frame1.OptionButton2.Enabled = True Else Me.Frame1.OptionButton1.Value = False Me.Frame1.OptionButton2.Value = False Me.Frame1.OptionButton1.Enabled = False Me.Frame1.OptionButton2.Enabled = False End If End With -- Regards, Tom Ogilvy "Steve" wrote in message ... I have checkboxJL if it is on it has a value of JL. I then have 2 optionbuttons that are used also. If the checkbox is flase I want to make 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 could turn on one of the option buttons weather the checkbox is true or false. How do you code to make this happen? TIA With Me.checkboxJL If Me.checkboxJL.value = True Then strJL = "JL" Else Me.checkboxJL = False End If End With If obReqJL = True Then strJLtype = Required If obOptJL = True Then strJLtype = Optional |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Checkbox with OPtion buttons
as always thanks tom
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Option Buttons/Radio Buttons | New Users to Excel | |||
option buttons | New Users to Excel | |||
option buttons | Excel Worksheet Functions | |||
Option Buttons | Excel Discussion (Misc queries) | |||
add size option to excel form checkbox | Excel Discussion (Misc queries) |