Using a ComboBox for Data Entry into a Cell

[Jon Turner]

I have a comboBox control. Any time the user sets focus to a cell in column
L, I
want to move the comboBox over to that cell, have the comboBox selected on
the
value of that cell. Thus using the combo box for the cell's data entry.
Can someone
provide me with an example of this ?

1. I don't want to use the DropDown List, because you can't control the
font.
2. I don't want to copy and paste a combo box for each cell because if the
user
adds a row, the comboBox doesn't come along with it.

Many Thanks

 

[Debra Dalgleish]

Perhaps you could adapt the technique described here:

http://www.contextures.com/xlDataVal11.html

which uses one combobox on a worksheet, to overlay cells with data
validation.

 

[Jon Turner]

THAT's exactly what I am looking for.. Many, Many Thanks

 

[Debra Dalgleish]

You're welcome. Thanks for letting me know that it helped.

 

[Guest]

This will move the combobox to the selected cell - it is an event procedure
so needs to be in the worksheet's code module (in the VBA Project Explorer
make sure the worksheet is selected):

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

If Not ((Intersect(Target, Range("L:L")) Is Nothing) And (Intersect(Target,
Range("I:I")) Is Nothing)) Then

ComboBox1.Top = Target.Top
ComboBox1.Left = Target.Left
Combobox1.Value = Target.Value

End If

End Sub


End Sub