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