Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default Unloading userform in MSComm event

Hi,

I'm using the MSComm function to communicate with a
microprocessor. Everything works fine except for one
thing:
at the end of my MSComm_OnComm() sub, I prompt a simple
message box, and after that message box, I want to close
the form (which has the MSComm control on it). Whenever I
include the Unload userform line after the message box
line, I get an error (actually, the entire VB shuts down
and an error log is created). Of course when I don't use
Unload userform, everything works fine. The
microprocessor is not sending any data at the time
either. It seems the error is occuring because the
userform is closing before the MSComm control has
stopped. What's going on here? Any help would be
appreciated. Thanks.

Sunny

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
Not Unloading a UserForm Mike[_49_] Excel Programming 1 January 29th 04 11:45 PM
Userform activate event question dan Excel Programming 1 January 26th 04 04:14 PM
MSCOMM markm Excel Programming 3 November 21st 03 02:49 PM
Passing ARGUMENTS between event procedures of a USERFORM jason Excel Programming 8 November 10th 03 07:36 PM
Loading MSComm.vbx into Excel VB ryan Excel Programming 0 August 10th 03 06:17 PM


All times are GMT +1. The time now is 10:08 PM.

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

About Us

"It's about Microsoft Excel"