Visual Basic error 400?????

jdavis9 · Mar 9th, 2002, 10:24 AM

I have been running the same code for an HMI screen using Excel for some time now and now that I am ready to put it out to Field use, I get a pop up message when pressing a button. The error is Visual Basic error 400.
If the sheet is not protected then there is no message box. The code still works but the pop up is a nuisance. Anyone tell me what is error 400? Or how can I block it?

Barrie Davidson · Mar 9th, 2002, 10:36 AM

Quote:

On 2002-03-09 09:24, jdavis9 wrote:
I have been running the same code for an HMI screen using Excel for some time now and now that I am ready to put it out to Field use, I get a pop up message when pressing a button. The error is Visual Basic error 400.
If the sheet is not protected then there is no message box. The code still works but the pop up is a nuisance. Anyone tell me what is error 400? Or how can I block it?

Copied from Excel's VBA help:

Quote:

Form already displayed; can't show modally (Error 400)

You can't use the Show method to display a visible form as modal. This error has the following cause and solution:

· You tried to use Show, with the style argument set to 1 – vbModal, on an already visible form.

Use either the Unload statement or the Hide method on the form before trying to show it as a modal form.

Does this help you out?

jdavis9 · Mar 9th, 2002, 02:10 PM

Well, actually it didn't directly, but it did get me looking in the right direction.
In the various lookups I was modifying a protected cell based on a value found in another file.
So I suppose it did actually help.

Thank you.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 9th, 2002, 10:24 AM	#1
jdavis9 Board Regular Join Date: Mar 2002 Location: TXU Posts: 337	I have been running the same code for an HMI screen using Excel for some time now and now that I am ready to put it out to Field use, I get a pop up message when pressing a button. The error is Visual Basic error 400. If the sheet is not protected then there is no message box. The code still works but the pop up is a nuisance. Anyone tell me what is error 400? Or how can I block it?

Mar 9th, 2002, 02:10 PM	#3
jdavis9 Board Regular Join Date: Mar 2002 Location: TXU Posts: 337	Well, actually it didn't directly, but it did get me looking in the right direction. In the various lookups I was modifying a protected cell based on a value found in another file. So I suppose it did actually help. Thank you.