Help w/ macro to run user form
 

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

Help w/ macro to run user form
 

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

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



.