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

Why not just use

UserForm1.show

???
--
HTH...

Jim Thomlinson


"William" wrote:

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

because i don't know it is work. i'm new.

anyway, i have try you statement. it is same problem. the error code is 91

this problem appear after check the "Microsoft ActiveX Data Objects 2.8
Library".

thx,
William

"Jim Thomlinson" ...
Why not just use

UserForm1.show

???
--
HTH...

Jim Thomlinson


"William" wrote:

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