Posted to microsoft.public.excel.programming

William[_8_] William[_8_] is offline

external usenet poster

Posts: 6

reference item

Dear,

i have a userform in excel and use follow statment to call it.

Dim a As Object
Set a = UserForm1
a.Show

it is work fine. but after i add ado reference, i got a error message when i
run above statement.
i don't why? any help?

thx,
William

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
Item numbers result in item description in next field in Excel	Cheryl MM	Excel Worksheet Functions	1	February 20th 07 03:51 PM
Pivot Item: removing non-existant item from the drop down	CinqueTerra	Excel Programming	2	February 23rd 06 08:47 PM
Reference to Item in Collection	Chad	Excel Programming	2	February 19th 06 02:37 PM
refer to drop down item as a sheet reference in a formula	milkman	Excel Worksheet Functions	2	January 18th 06 07:09 PM
cell reference to last item in a list	Lee	Excel Discussion (Misc queries)	1	February 2nd 05 08:07 PM

All times are GMT +1. The time now is 03:17 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us