Have you got the correct form name. I used Userform1 as that is the default,
but if you renamed it, you need to use that name.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"crew3407 " wrote in message
...
actually, i'm having another problem.

even when i reference the form class, there is an error message that
pops up.

Compile Error: Method or data memeber not found.

What am i doing wrong?


---
Message posted from http://www.ExcelForum.com/