Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Toolbox pops up | Excel Programming | |||
Is it possible to create a dynamic range in CONTROL TOOLBOX (form) | Excel Discussion (Misc queries) | |||
Using a Form as a macro toolbox | Excel Programming | |||
Controls Toolbox control vs Form Toolbox control | Excel Programming | |||
Form vs. Control Toolbox | Excel Programming |