Allow users to select records, by their criteria.

Mar 11th, 2002, 08:03 AM

Hi,

Heres a strange request, but I hope someone can help:

Need to be able to display change requests using USER input criteria in a form format.

User chooses environment(4 possible environments), then chooses date range(from-to), and excel will display the matching record/s.

Then the displayed records then must allow the USER to select individual records and display all information for the record.

Thanks.

Dave Hawley · Mar 11th, 2002, 08:06 AM

Hi

Have you had a look at Excels "Auto Filters" found under "Data" on the main menu? I think they maybe well suited.

rstone25 · Mar 11th, 2002, 08:49 AM

Hi,

Thats very helpful, but is there any way of hiding the data and presenting it in a nicer format (like a form)?

Thanks

Dave Hawley · Mar 11th, 2002, 08:57 AM

The 2 options would probably be a Data Form again found under data, or a Pivot table. The "Data Form" option would only be suited to a relatively small table.

After these 2 you would be needing a UserForm in VBA.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 11th, 2002, 08:03 AM	#1
Guest Posts: n/a	Hi, Heres a strange request, but I hope someone can help: Need to be able to display change requests using USER input criteria in a form format. User chooses environment(4 possible environments), then chooses date range(from-to), and excel will display the matching record/s. Then the displayed records then must allow the USER to select individual records and display all information for the record. Thanks.

Mar 11th, 2002, 08:06 AM	#2
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	Hi Have you had a look at Excels "Auto Filters" found under "Data" on the main menu? I think they maybe well suited.

Mar 11th, 2002, 08:49 AM	#3
rstone25 New Member Join Date: Feb 2002 Posts: 14	Hi, Thats very helpful, but is there any way of hiding the data and presenting it in a nicer format (like a form)? Thanks

Mar 11th, 2002, 08:57 AM	#4
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	The 2 options would probably be a Data Form again found under data, or a Pivot table. The "Data Form" option would only be suited to a relatively small table. After these 2 you would be needing a UserForm in VBA.