Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
need a excel spreadsheet for fleet maintenance - with formulas | Excel Discussion (Misc queries) | |||
creating a list of maintenance records for my car(s) Template ? | Excel Discussion (Misc queries) | |||
run setup in maintenance mode excel 2003 | Excel Discussion (Misc queries) | |||
Excel Inspect'n & Maintenance Record req'd under US DOT 396.3 | Setting up and Configuration of Excel | |||
excel template for housing maintenance records | Excel Discussion (Misc queries) |