Drop down on every cell in column

[enfantter]

Hi all,

I want to write a code which can, when executed create similar drop down lists on every cell in a column in excel - is this possible !?

Please let me know if i have explained myself in a clear fashion ...

[enfantter]

I'm thinking something like, if you click on one cell (in a row), then you get the possibility of selecting from a drop down list ...

[Bob Phillips]

Do you mean something like this



With Range("A1:A5")
.Validation.Delete
.Validation.Add Type:=xlValidateList, Formula1:="=dvList"
End With

[enfantter]

sorry i didnt get this one ...
what does this code do ?!

[Bob Phillips]

Adds data validation to a specified range.

[domfootwear]

Hi all,

I want to write a code which can, when executed create similar drop down lists on every cell in a column in excel - is this possible !?

Please let me know if i have explained myself in a clear fashion ...

You can use Combobox to do this

Try this code:


Sub Worksheet_Selectionchange(ByVal target As Range)
On Error Resume Next
With ComboBox1
If target.Column = 1 Then
.Visible = True
.Top = target.Top
.Height = target.Height
.Left = target.Left
.Width = target.Width
.LinkedCell = target
ElseIf Application.CutCopyMode = False Then
.Visible = False
End If
End With
End Sub

Private Sub ComboBox1_Change()
ActiveCell.Value = ComboBox1.Value
End Sub


Pls download file as below

[enfantter]

@domfootwear:

this is exactly what i need!! :)
now im just trying to figure out how you did it ...
did you initially insert a combobox on column A?

[enfantter]

How does the combobox get on to every cell in the column ?!
Is there something obvious i dont see ?!

[domfootwear]

How does the combobox get on to every cell in the column ?!
Is there something obvious i dont see ?!
Sorry I can not up file on this forum,
Pls see the video clip as below link:
http://www.4shared.com/file/228626523/afdfdffe/combo.html

[enfantter]

hmmm ... i cant see the file when i download it ..
can you send it ?!

[domfootwear]

hmmm ... i cant see the file when i download it ..
can you send it ?!
Can you send to me your private email address ?
My email: david@dowell-plus.co.kr