ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   New List in 2003 (https://www.excelbanter.com/excel-programming/379114-new-list-2003-a.html)

Robert[_32_]

New List in 2003
 
I have created a List in Excel 2003. Is it possible to bring up the Form for
the List (Data - Form) programmatically? I want to add a menu item for the
user to push to display the form for data entry into the List.

Thanks...
--
Robert Hill


Bob Phillips

New List in 2003
 
Range("C1").Select
ActiveSheet.ShowDataForm


--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"Robert" wrote in message
...
I have created a List in Excel 2003. Is it possible to bring up the Form
for
the List (Data - Form) programmatically? I want to add a menu item for
the
user to push to display the form for data entry into the List.

Thanks...
--
Robert Hill





All times are GMT +1. The time now is 02:05 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com