Set value of drop down list

[thevillain9@gmail.com]

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

[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)


<thevillain9@gmail.com> wrote in message
news:1131034904.875069.142320@g47g2000cwa.googlegroups.com...
> 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
>

[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
<thevillain9@gmail.com> wrote in message
news:1131034904.875069.142320@g47g2000cwa.googlegroups.com...
> 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
>