OLEObject on worksheet. Trying to get value from it.

G

Grant

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

William

Hi Grant

This worked for me

MsgBox ActiveSheet.ComboBox1.Value

--
XL2002
Regards

William

(e-mail address removed)

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

William

Hi Grant

This worked for me

MsgBox ActiveSheet.ComboBox1.Value


--
XL2002
Regards

William

(e-mail address removed)

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

William

Grant

If your dropdown list is created from the "Forms" toolbar, then..

MsgBox ActiveSheet.DrawingObjects("Drop Down 2").Value

--
XL2002
Regards

William

(e-mail address removed)

| Hi Grant
|
| This worked for me
|
| MsgBox ActiveSheet.ComboBox1.Value
|
|
| --
| XL2002
| Regards
|
| William
|
| (e-mail address removed)
|
| | | 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.
|
|
 
W

William

Grant

If your dropdown list is created from the "Forms" toolbar, then..

MsgBox ActiveSheet.DrawingObjects("Drop Down 2").Value


--
XL2002
Regards

William

(e-mail address removed)

| Hi Grant
|
| This worked for me
|
| MsgBox ActiveSheet.ComboBox1.Value
|
|
| --
| XL2002
| Regards
|
| William
|
| (e-mail address removed)
|
| | | 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.
|
|
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top