F
FJ
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.
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.