create a user input form

T

Travis

How do I create a form that will pop up whenever the
workbook is openned. And on that form I want to input a
customer account number text field and then have that
data passed to the excel worksheet "account number"
column.
 
C

Colo

Hi Travis

The code written as Auto_Open would be executed as soon as a workboo
is opened.
The following code shows DataForm. If this does not helps, you can us
an Userform instead of this.


Code
 
Top