VB Form Q

[spg2112]

Hello all,

A couple of easy form questions:

1. How do I have a form pull up when the file opens?

2. I want a calculation in one of the text boxes on the form. Is that possible?

Steve

 

[Andrew Poulsom]

1. In your Workbook_Open procedure put:

UserForm1.Show

or whatever your UserForm is called.

2. You would have to do the calculation in VBA and set the Text property of the TextBox to the result.

 

[spg2112]

Thanks! Andrew...got 1 to work fine..