View Cart

Quantity
Discounts

Money back
guarantee

Microsoft Visual Basic Error 400

Some user will get a a dialog titled Microsoft Visual Basic and it contains only the number 400, like the following dialog:

For users of our software, this error is typically caused by having the add-in file for the Spreadsheet Assistant for Excel 2003 installed as in add-in in Excel 2007 or Excel 2010.  The cure is to un-install it and install the correct file. Click File or Office Button, Options, Add-ins, GO. Uncheck Spreadsheet Assistant. Click Browse, go to C:\program files (x86)\add-ins and select Spreadsheet Assistant 2007-2013.xla.

If you are not using our software and get the above message, it means that your code is referring to something that does not exist or no longer exists.  The cure is is to step through your code line by line until you find the offending statement. From it you will hopefully get the clue to solve.  It could be referring to a variable that had been previously set to a range and then the workbook closed.  Or trying to run a command in a workbook that does not exist (very difficult to do!)

The cure for our users of the Spreadsheet Assistant who get a Microsoft Visual Basic 400 dialog is to do the following:

Excel 2007:
Open, click the round Office button, Excel Options, Add-ins, and Go (with manage excel addins selected)

Excel 2010
Open, Click File, Options, Add-ins, and Go (with manage excel addins selected)

both:

• Unclick the Spreadsheet Assistant in the Add-in dialog
• Do OK's and close and re-open Excel
• Repeat the above steps to redisplay the add-in dialog
• Click Browse, then My Computer, C Drive, Program files (or Program files X86), Add-ins
• Select the file "Spreadsheet Assistant 2007 2010.xla"
• Exit via OKs
• You will be told that the toolbars had to be reset either when you exit the dialogs or when you open Excel after exiting.
• Close and re-open Excel twice. This sets the toolbars in the right order the second time.