PDA

View Full Version : Solved: Help with Userform



CaptRon
02-08-2010, 12:04 PM
I hope to find some help with a project I'm working on. I've got an Excel spreadsheet filled with data (names, locations, job descriptions, etc.) ...each row a record relating to an employee.

I need to create a userform that permits the user to:
1. add, edit, and delete records
2. search records by one or more criteria
3. create a variety of reports based on filtered records

Access is not available to us, so I'm left to try this in Excel.

I've created a userform that will allow the user to add records and search one-by-one via a set of arrows, but that's as far as I've been able to get.

Does anyone have any examples or know where I can get more information specific to the needs noted above?

Thanks,

Ron

lucas
02-08-2010, 12:25 PM
See if this gives you any ideas Ron

mdmackillop
02-08-2010, 12:36 PM
Can you post a small sample Ron, and indicate which fields should be searchable.

CaptRon
02-09-2010, 10:54 AM
Here's a copy of the workbook I'm working with.

Ron

CaptRon
02-12-2010, 01:02 PM
Steve,

Looking at the file you sent, I'd say this may do the trick for me. I'll try to integrate some of these routines into the my workbook and see how it goes. Thanks for all your assistance.

Ron