Form question selecting records based on two columns in excel 2010

[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

 

[SkipVought]

hi,

Stock form or your own design?

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

 

[colkas2012]

Hi

I would not know where to start for my own design unfortunately hence I have been searching for some examples.

Uisng the basic form is ok but the Criteria search is not great and also I have a column of Hyperlinks and these work in the spreadsheet but do not open when in the standrad Excel Form.

Any ideas or pointers to some examples would be great.

Thanks

 

[colkas2012]

I have found how to create a form in excel VB. I have added a combo box. How do I make it look at a a column where for example the countries are seleced. Iassume I need code in the below.

Private Sub ComboBox1_Change()

End Sub

I want the form to then display other columns from the record selected. So if I picked France i would get

Country Server1 server2
France FRADC02 FREX01

Would the servera and 2 columns be txt boxes and how would they pick up the data.

Thanks