View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ExcelMonkey[_190_] ExcelMonkey[_190_] is offline
external usenet poster
 
Posts: 172
Default 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