create a user input form
 

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.

create a user input form
 

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

Sub Auto_Open()
ActiveSheet.ShowDataForm
End Sub

-------------------


--
Message posted from http://www.ExcelForum.com

create a user input form
 

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

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.