ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Form Toolbox pops up? (https://www.excelbanter.com/excel-programming/424461-form-toolbox-pops-up.html)

LaDdIe

Form Toolbox pops up?
 
When running a macro, VBA's form toolbox pop's up, even though VBA's code
window is not active,

Can anyone explain the cause, it only happens on a perticular workbook, I
checked my code, but can't seem to find anything that might be calling it.

LaDdIe

Bob Umlas[_3_]

Form Toolbox pops up?
 
Have you requested to compile the VBA code? Maybe it's encountering an
error...

"LaDdIe" wrote in message
...
When running a macro, VBA's form toolbox pop's up, even though VBA's code
window is not active,

Can anyone explain the cause, it only happens on a perticular workbook, I
checked my code, but can't seem to find anything that might be calling it.

LaDdIe




Nick

Form Toolbox pops up?
 
On Feb 20, 12:52*pm, LaDdIe wrote:
When running a macro, VBA's form toolbox pop's up, even though VBA's code
window is not active,

Can anyone explain the cause, it only happens on a perticular workbook, I
checked my code, but can't seem to find anything that might be calling it..

LaDdIe


i have this happen often, it happens when you tell code to stop at a
certain line of code, and then you remove the pause, and then run it
from a button or something else besides the visual basic editor. try
running the macro from with in the visual basic editor.

LaDdIe

Form Toolbox pops up?
 
Hi Bob & Nick

I reverted back to a previous version of my workbook, and then re-wrote my
VBA code again, now it runs without any problems whatsoever?

Thanks guys

"Nick" wrote:

On Feb 20, 12:52 pm, LaDdIe wrote:
When running a macro, VBA's form toolbox pop's up, even though VBA's code
window is not active,

Can anyone explain the cause, it only happens on a perticular workbook, I
checked my code, but can't seem to find anything that might be calling it..

LaDdIe


i have this happen often, it happens when you tell code to stop at a
certain line of code, and then you remove the pause, and then run it
from a button or something else besides the visual basic editor. try
running the macro from with in the visual basic editor.



All times are GMT +1. The time now is 03:23 AM.

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