Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 03 Trying to create input form | Excel Discussion (Misc queries) | |||
Trying to select a specific range based on the time value of user form input | New Users to Excel | |||
Trouble with saving user input in an Excel Form. | Excel Discussion (Misc queries) | |||
Detecting Input Change on User Form | Excel Programming | |||
Help with a User Input Form | Excel Programming |