Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Excel 2000 List Maintenance

I'm wanting to provide a list maintenance facility for data held as a list
within the current workbook.
I've created a data input worksheet (which is answers to various questions),
but also want to allow users to browse through previous sets of answers held
as a list.

The Data Form does the job, but I'd like to improve the form layout without
using Access.

I think I'll have to use a Userform, but do I need to program all the basic
record navigation/update operations?
This approach also means I can't use the formatting etc from my input
worksheet.
So ideally I'd like to provide the operations from buttons on my worksheet.

VLOOKUP provides good browse facilities, but adding and deleting records is
messy.

Any suggestions or examples welcome.

Steve


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
need a excel spreadsheet for fleet maintenance - with formulas RJL Excel Discussion (Misc queries) 2 April 4th 23 11:20 AM
creating a list of maintenance records for my car(s) Template ? Jeff Excel Discussion (Misc queries) 4 August 29th 08 05:01 AM
run setup in maintenance mode excel 2003 Anna Excel Discussion (Misc queries) 1 November 22nd 06 08:48 PM
Excel Inspect'n & Maintenance Record req'd under US DOT 396.3 Laura G. Setting up and Configuration of Excel 0 August 30th 06 11:43 PM
excel template for housing maintenance records Herbgrinder Excel Discussion (Misc queries) 1 June 8th 06 08:30 AM


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