Help w/ macro to run user form

GMet · Sep 7, 2004

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

Ron de Bruin · Sep 7, 2004

Typo?

endsub

Must be
end sub

GMet · Sep 7, 2004

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?

Must be
end sub

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

"GMet" <[email protected]> wrote in

message news:[email protected]...