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.
|
|