Set value of drop down list

T

thevillain9

I've created a drop down list(list A) in a cell, using the
data->validation list creating thing. However based on the selection
of another list(list B), i want to default the values of list A, to one
of the list items. I was trying to do it in VBA, but i couldn't just
change the cell.value. The only way I could change it was by selecting
the corrrect one in the sheet. thanks in advance for the help.

-Ricky
 
B

Bob Phillips

I was able to do it with DV using

Range("E1").Value = "Lynne"

I could even set a value not in the list without complaints.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
C

Chris Lavender

Hi Ricky

The way I've done this in the past is to have the DV list as a series of
OFFSET formulae, ie have your subsets for List A in adjoining columns, a
MATCH formula to find which you've selected in List B and
=OFFSET(M1,0,matchresultreference), =OFFSET(M2,0,matchresultreference) etc
for the List A DV table

Hope this seems clear

Best rgds
Chris Lav
 
Top