Visual Basic

[Coldfusion]

Could anyone tell me the code to make a visual basic form to display as soon as I open a spreadsheet?

[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.

[hertz]

The format of my answer above does not make clear the two lines: 1st line - Load helloFrm 2nd line - helloFrm.show