create a user input form

  • Thread starter Thread starter Travis
  • Start date Start date
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.
 
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
 
-----Original Message-----
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.
.
Click to expand...

thank you for the response. that helps big time, now to
the other part of my question.

I want to input a customer account number text field and
then have that data passed to the excel
worksheet "account number" column.
 
Back
Top