Donate SIGN UP
Home > Technology > Visual Basic

Visual Basic

Avatar Image
Coldfusion | 14:07 Thu 18th Mar 2004 | Technology
2 Answers
Could anyone tell me the code to make a visual basic form to display as soon as I open a spreadsheet?
prev Duron CPU names.
  
next how do i....
Gravatar

Answers

1 to 2 of 2rss feed

Best Answer

No best answer has yet been selected by Coldfusion. Once a best answer has been selected, it will be shown here.

For more on marking an answer as the "Best Answer", please visit our FAQ.
Avatar Image hertz
You need to set up a macro within the spreadsheet called Auto_Open. In this macro you need two lines: (say your VB form is called helloFrm) Load helloFrm helloFrm.Show Close down the spreadsheet, clicking Save on the way out. When you re-open your spreadsheet the form should appear with it.
20:17 Fri 09th Apr 2004
Avatar Image hertz
The format of my answer above does not make clear the two lines: 1st line - Load helloFrm 2nd line - helloFrm.show
20:20 Fri 09th Apr 2004

1 to 2 of 2rss feed

Do you know the answer?

Visual Basic

Answer Question >>