View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Andy Andy is offline
external usenet poster
 
Posts: 414
Default Does Userform exist?

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