Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 19
Default form that retrieves existing data from table and allows editing

Hello,

I have a week to create a user form:

1. Which can be distributed to others and work with their version of excel -
2003 most common.

2. Allow them retrieve previously entered data from the table and
edit/change it as well as enter it?


Are there any addins which can make these but can be used by the user
without the add-in? Or, any links?

Thanks,

John

  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 345
Default form that retrieves existing data from table and allows editing

John try looking for a template that you can modify to suit your application:
start he
http://office.microsoft.com/en-us/te...px?ofcresset=1

"John L" wrote:

Hello,

I have a week to create a user form:

1. Which can be distributed to others and work with their version of excel -
2003 most common.

2. Allow them retrieve previously entered data from the table and
edit/change it as well as enter it?


Are there any addins which can make these but can be used by the user
without the add-in? Or, any links?

Thanks,

John

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 19
Default form that retrieves existing data from table and allows editin

Hello again,

I found
http://contextures.com/xlUserForm01.html

whose logic and steps are the first part of my required form.

After reading this, my question is

1. how do I retrieve previously entered data into this form structure for
editing?

2. program validity checks, ranges into the form?

John

"Ron@Buy" wrote:

John try looking for a template that you can modify to suit your application:
start he
http://office.microsoft.com/en-us/te...px?ofcresset=1

"John L" wrote:

Hello,

I have a week to create a user form:

1. Which can be distributed to others and work with their version of excel -
2003 most common.

2. Allow them retrieve previously entered data from the table and
edit/change it as well as enter it?


Are there any addins which can make these but can be used by the user
without the add-in? Or, any links?

Thanks,

John

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
Custom Form for updating data in an existing spreadsheet Xhawk57 Excel Discussion (Misc queries) 2 November 12th 08 04:45 PM
transfering data from word form to an existing spreadsheet Jose Excel Discussion (Misc queries) 1 October 15th 07 07:56 PM
How to change data in cells of an existing saved form- Maggie Excel Discussion (Misc queries) 0 October 26th 06 09:40 PM
Whatsthe formula which retrieves a # from a multiplication table DS Excel Worksheet Functions 4 September 26th 06 05:28 PM
Formula retrieves wrong data Newmoon Excel Discussion (Misc queries) 2 August 11th 05 04:02 PM


All times are GMT +1. The time now is 11:38 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"