Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 24
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,452
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Date field in user form & Loading a user form on opening workbook Balan Excel Programming 1 May 24th 08 03:40 PM
Help sought re vbmodeless form rendering a class module useless The Clint Excel Programming 11 April 7th 07 03:47 PM
Errant Tool Bar David Shepard Excel Discussion (Misc queries) 0 January 25th 06 11:45 PM
Removing errant apostrophes C Glenn Excel Worksheet Functions 4 October 14th 05 05:39 PM
vbModeless user form crashes Excel Plutopotamus Excel Programming 2 January 28th 05 03:19 PM


All times are GMT +1. The time now is 08:20 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"