| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data Form question
I have a worksheet with the titles in the first row and
data below it that is basically an address book. I would like to have the worksheet open with a data form ready to use. How can I do this? Thank you. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Data Form question
Option Explicit
Sub auto_open() With Worksheets("sheet1") .Select Application.DisplayAlerts = False .ShowDataForm Application.DisplayAlerts = True End With End Sub might be ok. WylieC wrote: I have a worksheet with the titles in the first row and data below it that is basically an address book. I would like to have the worksheet open with a data form ready to use. How can I do this? Thank you. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula (off form) that completes form data based on a result | Excel Worksheet Functions | |||
| excel form. Need data extracted to spreadsheet each time a form co | Excel Discussion (Misc queries) | |||
| Create a form in excel so I can enter data using DataForm | Excel Discussion (Misc queries) | |||
| how to get a data form to fill you own exel sheet (was data-form | Excel Worksheet Functions | |||
| Form question | Excel Programming | |||
Linear Mode
