E
ExcelMonkey
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
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