Help with drop down list selection

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to populate a drop down list with data from sheet2,a1-a50 (which
is not very hard), but when the user selects a name from the list I want it
to return a value that corresponds to the selection.

Basiclly when you select the first name from the list(sheet2,a1), I want it
to return the value from sheet2,b1. Also I want the listbox/combobox to be
bound to a column of cells

When when you select 'A' I want it to return 'B' instead.

Can anyone please help me write code that can do this, I've tried the Data
Validation tool with no luck and I tried creating a combo box with failure
also.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Data validation drop down list selection change 4
Junp start my Select Case Macro 12
Data Validation used with VLookUp function 1
Help with creating drop down 1
Excell to Web Form filling macro 0
Update a spreadsheet based on a drop-down selection 2
How to dynamically change the list in drop down list based on thevalue of another cell? 1
Drop down list - link to another worksheet 4

Back
Top