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