Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I've had this trouble in various different bits of code and can't figure out
how to correct it. Here's the situation: I've selected an item from a ListBox contained within a UserForm. The UserForm appears on sheet "A". Once I select the item, Excel gets busy populating a whole bunch of stuff on sheet "B". In the process it is supposed to check to see if the value of OptionButton1 on sheet "B" is "True". The bit of code that it has trouble with is this: If Worksheets("B").Shapes("OptionButton1").Value = True Then ' do stuff At first, I had "OLEObjects" in the place of "Shapes", but it didn't like that either. How do I go about checking the value of an ActiveX control embedded on a worksheet, regardless of whether the worksheet is active? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Optionbutton troubles | Excel Worksheet Functions | |||
for each optionbutton | Excel Programming | |||
OptionButton | Excel Programming | |||
Better Way to Use OptionButton | Excel Programming | |||
Better Way to Use OptionButton | Excel Programming |