Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can't read optionbutton values
Hello all,
I'm trying to read the boolean value of 50 option buttons into column A of a worksheet so that column A will be, for example TRUE FALSE TRUE TRUE .. . . . etc. The following routine does not work, but I don't know why (I get a runtime error 438): Sub test() For i = 1 To 50 Worksheets("Sheet1").Cells(i, 1) = Worksheets("Sheet1").OLEObjects _("Optionbutton" & i).Value Next i End Sub Later on, I'll want to read the boolean values in column a to change the value properties of option buttons 1 through 50. Can anyone help me with this? Thanks! Jeff |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Values?? Please Read Below. | New Users to Excel | |||
Read Excel row values | Excel Worksheet Functions | |||
read the values from a excel row | Excel Worksheet Functions | |||
Read series values range of a chart | Charts and Charting in Excel | |||
How do I read values from a line chart? | Charts and Charting in Excel |