C
cmpcwil2
Hi,
I am looping through comboboxes in the active sheet using the following
code:
For Each myDD In ActiveSheet.OLEObjects
If TypeOf myDD.Object Is ComboBox Then
'ctrl is a checkbox, if the checkbox is checked then it will loop
to the
'corresponding comboBox
If myDD.Index = ctrl.Index - 1 Then
msgbox myDD.value
end if
end if
next myDD
so if a check box value is true then I want the value of the combobox
that is located next to the checkbox on the sheet to be displayed. The
above code does not work as there is no value property for this
object.
is there a better way of going about this? or can it be achieved this
way?
thanks in advance for any assistance
I am looping through comboboxes in the active sheet using the following
code:
For Each myDD In ActiveSheet.OLEObjects
If TypeOf myDD.Object Is ComboBox Then
'ctrl is a checkbox, if the checkbox is checked then it will loop
to the
'corresponding comboBox
If myDD.Index = ctrl.Index - 1 Then
msgbox myDD.value
end if
end if
next myDD
so if a check box value is true then I want the value of the combobox
that is located next to the checkbox on the sheet to be displayed. The
above code does not work as there is no value property for this
object.
is there a better way of going about this? or can it be achieved this
way?
thanks in advance for any assistance