View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
gmet gmet is offline
external usenet poster
 
Posts: 10
Default Help w/ macro to run user form

No typo. The original macro was in Module1. When I copy
and paste it into Module3 it does not work. When I take
it back to Module1, it works. I am completely mystifed.

GMet

-----Original Message-----
Typo?

endsub


Must be
end sub


--
Regards Ron de Bruin
http://www.rondebruin.nl


"GMet" wrote in

message ...
I have a problem with a macro that calls a user form.

It
will not run in Module3. However, when I copy it to
Module1, it works just fine.

Sub ShowPiker()
Piker.show
endsub

That will not run in Module3 but it works fine in
Module1.

Anybody have a clue why this would be the case?

TIA

GMet



.