Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
OLEObject on worksheet. Trying to get value from it.
Hi there.
I have a drop down list on a normal excel worksheet (not a user form), which I am trying to grab its value from. I am using the following: ActiveSheet.OLEObjects("cboLine").Object.Value but it keeps saying "Unable to get OLEObjects property from the worksheet class". How might I go about fixing this? Thanks in advance for the replies, Grant. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
OLEObject on worksheet. Trying to get value from it.
Hi Grant
This worked for me MsgBox ActiveSheet.ComboBox1.Value -- XL2002 Regards William "Grant" wrote in message ... | Hi there. | | I have a drop down list on a normal excel worksheet (not | a user form), which I am trying to grab its value from. I | am using the following: | | ActiveSheet.OLEObjects("cboLine").Object.Value | | but it keeps saying "Unable to get OLEObjects property | from the worksheet class". | | How might I go about fixing this? | | Thanks in advance for the replies, | Grant. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
OLEObject on worksheet. Trying to get value from it.
Hi Grant
This worked for me MsgBox ActiveSheet.ComboBox1.Value -- XL2002 Regards William "Grant" wrote in message ... | Hi there. | | I have a drop down list on a normal excel worksheet (not | a user form), which I am trying to grab its value from. I | am using the following: | | ActiveSheet.OLEObjects("cboLine").Object.Value | | but it keeps saying "Unable to get OLEObjects property | from the worksheet class". | | How might I go about fixing this? | | Thanks in advance for the replies, | Grant. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
OLEObject on worksheet. Trying to get value from it.
Grant
If your dropdown list is created from the "Forms" toolbar, then.. MsgBox ActiveSheet.DrawingObjects("Drop Down 2").Value -- XL2002 Regards William "William" wrote in message ... | Hi Grant | | This worked for me | | MsgBox ActiveSheet.ComboBox1.Value | | | -- | XL2002 | Regards | | William | | | | "Grant" wrote in message | ... | | Hi there. | | | | I have a drop down list on a normal excel worksheet (not | | a user form), which I am trying to grab its value from. I | | am using the following: | | | | ActiveSheet.OLEObjects("cboLine").Object.Value | | | | but it keeps saying "Unable to get OLEObjects property | | from the worksheet class". | | | | How might I go about fixing this? | | | | Thanks in advance for the replies, | | Grant. | | |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
OLEObject on worksheet. Trying to get value from it.
Grant
If your dropdown list is created from the "Forms" toolbar, then.. MsgBox ActiveSheet.DrawingObjects("Drop Down 2").Value -- XL2002 Regards William "William" wrote in message ... | Hi Grant | | This worked for me | | MsgBox ActiveSheet.ComboBox1.Value | | | -- | XL2002 | Regards | | William | | | | "Grant" wrote in message | ... | | Hi there. | | | | I have a drop down list on a normal excel worksheet (not | | a user form), which I am trying to grab its value from. I | | am using the following: | | | | ActiveSheet.OLEObjects("cboLine").Object.Value | | | | but it keeps saying "Unable to get OLEObjects property | | from the worksheet class". | | | | How might I go about fixing this? | | | | Thanks in advance for the replies, | | Grant. | | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Trying to get/set contents of embedded file using Excel OleObject | Excel Programming | |||
Reference oleobject within shape group | Excel Programming | |||
Need to cast OleObject to CombBbox | Excel Programming | |||
OLEobject on the sheet | Excel Programming | |||
Using a variable to represent a Checkbox Name(OLEObject) | Excel Programming |