Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to bring up a data form with VBA
I've got a table of data that I would like to display in Excel's built-in
data form that you can call up manually by highlighting a range of data and selecting the Form command from the Data menu. However, I would like to write a VBA procedure that would enable the user to do this by simply clicking on the command button. The region I would like to display in this form could be described as Range("DataTable").CurrentRegion Can anyone tell me what code I can use to bring up Excel's built-in data form to display the data in that range? Thanks in advance. Paul |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to bring up a data form with VBA
Thanks for your help again, Tom.
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to bring up a data form with VBA
My mistake. Glad you fixed it.
-- Regards, Tom Ogilvy Paul James wrote in message ... Actually a small modification is needed to get the code to work. ShowDataForm isn't a method of the Application object, but it is a method of the ActiveSheet object. So the working code would be: Range("DataTable").CurrentRegion.Name = "Database" ActiveSheet.ShowDataForm Again, thanks for showing me how to do this, Tom. Paul |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Bring filtered data from another file | Excel Discussion (Misc queries) | |||
Macro to bring up Data Form | Excel Discussion (Misc queries) | |||
bring in data from one worksheet to another | Excel Worksheet Functions | |||
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 |