Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Using data forms
I would like to create a worksheet where the data is entered in a data forms
dialog box. Is there a way to set the worksheet up so that when I bring it up the data form dialog box would automatically show? Also is there a way that I would be be able to to switch between the data form and the worksheet? Thanks |
#2
|
|||
|
|||
You can switch between data form and worksheet by using the menu option
DataForm... options You could record a macro doing that and assign it to a toolbar button or one on the sheet. If you want it presented on opening the workbook, you could use the workbook_open() event thus Private Sub Workbook_Open() Worksheets("Sheet1").ShowDataForm End Sub -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England HIS "slaforest" wrote in message ... I would like to create a worksheet where the data is entered in a data forms dialog box. Is there a way to set the worksheet up so that when I bring it up the data form dialog box would automatically show? Also is there a way that I would be be able to to switch between the data form and the worksheet? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Removing blank rows in a worksheet | Excel Worksheet Functions | |||
Copying conditional formatting...HELP PLEASE!!!! | Excel Worksheet Functions | |||
Help making a chart that doesn't graph cells without data? | Excel Discussion (Misc queries) | |||
Forms Toolbar vs. Control Toolbox vs. Data Validation for drop dow | Excel Discussion (Misc queries) | |||
Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) |