ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Disable user forms being displayed in the VB editor?? (https://www.excelbanter.com/excel-programming/410775-disable-user-forms-being-displayed-vbulletin-editor.html)

Chrisso

Disable user forms being displayed in the VB editor??
 
Hi All

Whenever I have a user form in my project I am annoyed by the fact
that the VB editor constanly pop-ups during debug etc with the form
displayed instead of the code I have been working on and debugging.

Is there a way to tell Excel not to display user forms in this way?

Chrisso

Jim Rech

Disable user forms being displayed in the VB editor??
 
It is annoying to get the form when you and the module and vice versa.
While I don't know a way to stop Excel from doing this, when you get the
form just press F7 to go directly to the code. (And Shift-F7 to go the
other way.)

--
Jim
"Chrisso" wrote in message
...
| Hi All
|
| Whenever I have a user form in my project I am annoyed by the fact
| that the VB editor constanly pop-ups during debug etc with the form
| displayed instead of the code I have been working on and debugging.
|
| Is there a way to tell Excel not to display user forms in this way?
|
| Chrisso




All times are GMT +1. The time now is 01:32 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com