Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Syntax to return the value of a control by reference
This is driving me crazy!!
I have a number of controls on a sheet. (Check boxes, option buttons and combo boxes). I know that "cmbTitle.value" or "optBlue.value" sets/returns what I want for an individual control but how do you refer to the controls in a loop without using their individual names? ie I want a macro to loop through the controls and return or set the controls' values to/from an array. I have been using: thisworkbook.sheets(s).OLEobject(x)...... where x=the control's name. This works for pulling up their names etc. but "OLEobject" does not have a "value" property. While about it, how do you return the type of a control ie whether it is a combo of check box? Please help...... I don't have much hair left! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula using 2 points of reference to return a value from a table | Excel Worksheet Functions | |||
ADD A RETURN BUTTON WHEN GOING TO FORMULA REFERENCE LINKS | New Users to Excel | |||
if the value of a cell in a range is not blank, then return the v. | Excel Worksheet Functions | |||
what is the correct syntax for an allowable circular reference? | Excel Discussion (Misc queries) | |||
Copying list-box control | Excel Discussion (Misc queries) |