Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Option Button Value
I have a form that is called from a proceding form.
Before the form is called, I load listbox. I also want set the enable property of a button on the form to FALSE based on a option button value in a preceding form. The code below is failing on the OptionButton2.Value = xlOn line of the code. What is the proper syntax for an Option BUtton value? Sub WorkSheetSummary() Dim ws As Worksheet For Each ws In ThisWorkbook.Worksheets If ws.Visible = True Then WorkSheetSelectForm.ListBox1.AddItem (ws.Name) End If Next If OptionButton2.Value = xlOn Then ContinueButton.Enable = False End If WorkSheetSelectForm.Show End Sub Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Option Button Value
Replaced
ContinueButton.Enable = False With Userform2.ContinueButton.Enable = False -----Original Message----- I have a form that is called from a proceding form. Before the form is called, I load listbox. I also want set the enable property of a button on the form to FALSE based on a option button value in a preceding form. The code below is failing on the OptionButton2.Value = xlOn line of the code. What is the proper syntax for an Option BUtton value? Sub WorkSheetSummary() Dim ws As Worksheet For Each ws In ThisWorkbook.Worksheets If ws.Visible = True Then WorkSheetSelectForm.ListBox1.AddItem (ws.Name) End If Next If OptionButton2.Value = xlOn Then ContinueButton.Enable = False End If WorkSheetSelectForm.Show End Sub Thanks . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Option button | New Users to Excel | |||
Option Button Help PLEASE!! | Excel Worksheet Functions | |||
keep source formatting is not an option in paste option button | Excel Discussion (Misc queries) | |||
Option Button Help | Excel Worksheet Functions | |||
Option button | Excel Programming |