Posted to microsoft.public.excel.programming

grant

external usenet poster

Posts: 24

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.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Trying to get/set contents of embedded file using Excel OleObject	Rich[_22_]	Excel Programming	1	April 15th 04 07:21 AM
Reference oleobject within shape group	Andrew[_16_]	Excel Programming	4	December 24th 03 02:31 AM
Need to cast OleObject to CombBbox	Liline	Excel Programming	1	August 29th 03 03:32 PM
OLEobject on the sheet	Ryan[_6_]	Excel Programming	1	August 3rd 03 03:15 PM
Using a variable to represent a Checkbox Name(OLEObject)	Mike Cooper	Excel Programming	1	July 16th 03 09:40 PM

All times are GMT +1. The time now is 12:30 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us