Dropdown Lists

[dezian]

Could anybody help, I have a spread sheet that has a top row of dropdown lists, when selecting any cell in the row directly below the drop down I would like the value from the dropdown to be put into the originaly selected cell. I.e. If A1 has a dropdown with values 1 to 10 in it, selecting cell A10, then selecting a value from the list, thus transporting the value from A1 to A10.

If this cannot be done due to A10 automaticaly being de selected when the list in A1 is selected, could then a selected cell, say A5 import the value from A1's list and then ignore any change in A1 once the selected cell A5 has a value in it? Hope someone can help, my heads starting to throb!!

Cheers Andy Hickson

 

[SkipVought]

dezian,

Not sure I understand.

A1 has a combobox.

The List is valses from 1 to 10

You want the result in A1 to be placed in column A with the row corresponding to the selection?

Private Sub ComboBox1_Change()
    With ComboBox1
        Cells(.Value, 1).Value = [A1]
    End With
End Sub

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[xlbo]

or just use data validation and have ALL the cells in that column have their own dropdowns....

Rgds, Geoff
[blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244