Hi, I have what is probably a very basic userform problem but as I am new to
VBA, it is completely baffling me.

I have been creating some very short macros with userforms and up until a
little while ago, everything was working fine. All of sudden, though,
userforms are giving me a big problem. I can run the macros, but when it
comes time to display a userform, it takes me back into the VB editor and
won't let the macro continue. This is happening on things that previously
ran correctly. If I add "vbmodeless" after "UserForm1.Show" things seem to
run correctly but why all of a sudden do I have to do this?

Right now I am using Excel 2007.

Thanks in advance for any information.

Hi, nevermind. Out of desperation I finally just shut the computer down and
restarted and everything is okay now. The program crashed on when I was
running another macro and I guess maybe it was holding on to the ghost of
another userform or something. I guess that's why I had to use "vbmodeless"
to get things to work.





"FJ" wrote:

Hi, I have what is probably a very basic userform problem but as I am new to
VBA, it is completely baffling me.

I have been creating some very short macros with userforms and up until a
little while ago, everything was working fine. All of sudden, though,
userforms are giving me a big problem. I can run the macros, but when it
comes time to display a userform, it takes me back into the VB editor and
won't let the macro continue. This is happening on things that previously
ran correctly. If I add "vbmodeless" after "UserForm1.Show" things seem to
run correctly but why all of a sudden do I have to do this?

Right now I am using Excel 2007.

Thanks in advance for any information.