ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   VBmodeless user form errant behaviour (https://www.excelbanter.com/excel-programming/413195-vbmodeless-user-form-errant-behaviour.html)

JLR-Mart

VBmodeless user form errant behaviour
 
I have a macro that uses a user form for data entry which works very well
UNTIL I make the userform modeless. I know that making it modeless means that
some code will execute anyway but it seems to be excuting code that shouldn't
execute until AFTER the OK button is pressed.

Anyone know what the issue could be here. I'd post the code but it's several
modules and hundreds of lines :-(((

RB Smissaert

VBmodeless user form errant behaviour
 
Post the essentials of the code.
Actually, by picking out the essential bits you may see where the problem
is.
Have you put a Stop in the code and stepped through it?

RBS


"JLR-Mart" wrote in message
...
I have a macro that uses a user form for data entry which works very well
UNTIL I make the userform modeless. I know that making it modeless means
that
some code will execute anyway but it seems to be excuting code that
shouldn't
execute until AFTER the OK button is pressed.

Anyone know what the issue could be here. I'd post the code but it's
several
modules and hundreds of lines :-(((




All times are GMT +1. The time now is 12:01 PM.

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