Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 :-((( |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 :-((( |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date field in user form & Loading a user form on opening workbook | Excel Programming | |||
Help sought re vbmodeless form rendering a class module useless | Excel Programming | |||
Errant Tool Bar | Excel Discussion (Misc queries) | |||
Removing errant apostrophes | Excel Worksheet Functions | |||
vbModeless user form crashes Excel | Excel Programming |