Visual Basic Programming Script Problem

Asked By acrylos 10 points N/A Posted on - 03/25/2012

I want to add pop up calendar and I have done add in through Excel. When I select references in VB, I get a Visual Basic error 400. There is an image of a red button with an "X" on it.

My only selections are "OK" and "HELP". If I select "HELP", it forward me to a blank page in a new window. Can anyone tell me what this error means?

Thanks.

• Status: Open
• Question Views: 855
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Excel

Answered By Estillero State 5 points N/A #91173

Visual Basic Programming Script Problem

Hi Acrylos,

The error you mentioned above is caused by a component referenced by your program that doesn't exists anymore. To figure out the offending code, you have to step through your code line by line in a debug mode to determine what is wrong. In your case it is certain that it is the calendar add in you tried to reference. Try unreferencing the add in first and see if the problem is still reproducible. Try not to use it in excel then reference it in your VB code once again. Another area to check is your variables in the VB program. It is possible that the program ran across a variable whose value is not valid anymore. See if the problem persists.

 

I hope it helps.

About Estillero State

Questions
7

Answers
70

Best Answers
7

• Vote Up 0 Vote Down

• Posted on - 04/24/2012
• Question Category: MS Excel