Excel Form using selected criteria

[colkas2012]

Hi

I have a spreadsheet with the following columns

Name, Location, AD, Exchange, Backup, Activirus etc.....

What I want is a user to be able to enter in a form

Name, Location and the other columns are filled in automatically in the form from the slection of the Name and Location.

I tried using Form which looks good but does not allow me to search but just go to Next and Previous. this would be ideal if it let me search on location even.

It may be a VB question. I have searched alot for a solution but no luck so far.

Any ideas please

Thanks

 

[colkas2012]

Hi

Another note on this, I have used the Criteria button on the form, this searches but after a few searches it does not work to well. Also if I try and use a wildcard like Lee* it does not bring in the result.

Thanks

 

[colkas2012]

Hi

Another issue with the form is that I have a Hyperlink column. These work ok in the spreadsheet but within the Form they do not link, it does not allow you to click on it to go through to the link.

Any ideas

Thanks

 

[SkipVought]

hi,

but after a few searches it does not work to well.

Exactly what does that mean? Please give examples.

If you are using a UserForm, please post in forum707 for better results.

Otherwise, the built-in form that you may be referring to does not have these kinds of features, and you may be better off either designing your own form, or asking yourself, why you are putting this interface between the user & the sheet?

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[lionelhill]

... and if you're basically setting up a database, you might also consider database software (e.g. Access?) rather than Excel, which although capable, may not be the perfect fit.