Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 23
Default 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

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,726
Default 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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 list Adele Excel Discussion (Misc queries) 3 June 10th 09 12:50 PM
Excel 2003. Data/Validation/Settings - Allow/List: sizing list? Bart Excel Discussion (Misc queries) 1 February 20th 09 01:40 PM
2003 List designs KJ Excel Discussion (Misc queries) 2 January 11th 08 12:39 PM
Name a list in Excel 2003? Alun Jones Excel Discussion (Misc queries) 8 July 4th 07 12:32 PM
List feature in XL 2003 Dave F Excel Discussion (Misc queries) 0 November 14th 06 02:46 PM


All times are GMT +1. The time now is 10:05 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"