Question Display Macro Warning Messages and Changing Active Printer

Olivia

New member
Joined
Mar 14, 2009
Messages
3
Programming Experience
Beginner
I have a vb.net programme that has a linkage with an excel file. The excel file will execute a series of macros according to data entered to the vb.net programme. There might be some warning messages (using msgbox()) on the validity of some of the information entered.

The issue is, I couldn't get the warning message boxes to show as pop-up ones. They would just show as one of the programmes running in the Windows Taskbar. The excel would not continue to run as long as any one of the messages is not clicked.

Is there a way to make the excel msgbox to pop-up?

Many thanks in advance!!

Updated: I eventually got another issue and I think it would be better to put 2 into one thread...

How to change the active printer (default) in excel through vb.net? I only got the name but don't have the port address of the printer...
 
Last edited:
Back
Top