Look at Chip Pearson's page on programming the VBE
http://www.cpearson.com/excel/vbe.htm
--
Regards,
Tom Ogilvy
"Andy" wrote in message
...
Hi All
I have a macro that makes use of a UserForm for gathering data from the
user. While the userform should always exist on the users' machines this
might not always be the case. Is anybody aware of a way of checking to
see
if a UserForm exists in the Personal.xls workbook so I can handle such
instances? If it doesn't then there is obviously a compile error so I
have
had a look at the #const and #if... directives but can't figure it out.
Thanks
Andy