View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Mike[_113_] Mike[_113_] is offline
external usenet poster
 
Posts: 40
Default Can't call a sub in a UserForm using Application.Run

It appears that Application.Run can be in a Standard Module, a Class Module
or a Userform module and it cannot call a sub in a Userform Module. Thanks.
"joel" wrote in message
...

Is the userform loaded? You aren't suppose to call user form routine
dirrectly. If yo have common code move the macro from the userform to a
module and then call the routine.. You can call the common code from a
userform, right!


--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread:
http://www.thecodecage.com/forumz/sh...d.php?t=181173

Microsoft Office Help