| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Annoying userform popping up in VBE
When I create a macro with a userform, whenever I test run the macro
and it hangs, when I click on the stop button, the window goes to the userform window and I have to click back to the code. Is there anyway to stop this annoying behavior? Thanks! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Annoying userform popping up in VBE
Hit the reset button instead.
-- Regards, Tom Ogilvy "davegb" wrote: When I create a macro with a userform, whenever I test run the macro and it hangs, when I click on the stop button, the window goes to the userform window and I have to click back to the code. Is there anyway to stop this annoying behavior? Thanks! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Annoying userform popping up in VBE
Tom Ogilvy wrote: Hit the reset button instead. I guess I have my terminology wrong, it's the reset button I've been hitting. It activates the userform window. Any way to get it to go to the code window I've been working in? -- Regards, Tom Ogilvy "davegb" wrote: When I create a macro with a userform, whenever I test run the macro and it hangs, when I click on the stop button, the window goes to the userform window and I have to click back to the code. Is there anyway to stop this annoying behavior? Thanks! |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Annoying userform popping up in VBE
Unfortunately, VBA is trying to help you with this annoying
behavior. There is no way around it. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "davegb" wrote in message ups.com... When I create a macro with a userform, whenever I test run the macro and it hangs, when I click on the stop button, the window goes to the userform window and I have to click back to the code. Is there anyway to stop this annoying behavior? Thanks! |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Annoying userform popping up in VBE
Chip Pearson wrote: Unfortunately, VBA is trying to help you with this annoying behavior. There is no way around it. I was afraid someone was going to tell me that. Thanks for the reply. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "davegb" wrote in message ups.com... When I create a macro with a userform, whenever I test run the macro and it hangs, when I click on the stop button, the window goes to the userform window and I have to click back to the code. Is there anyway to stop this annoying behavior? Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why does the research box keep popping up? | Excel Discussion (Misc queries) | |||
| Popping out Message Box! | Excel Discussion (Misc queries) | |||
| Clipboard Keeps Popping Up | Excel Discussion (Misc queries) | |||
| Preventing VBA editor from Popping up | Excel Programming | |||
| MsgBox keeps popping up | Excel Programming | |||
Linear Mode
