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

Perhaps you could adapt the technique described he

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

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

Jon Turner wrote:
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
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

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



"Debra Dalgleish" wrote in message
...
Perhaps you could adapt the technique described he

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

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

Jon Turner wrote:
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
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

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

Jon Turner wrote:
THAT's exactly what I am looking for.. Many, Many Thanks



"Debra Dalgleish" wrote in message
...

Perhaps you could adapt the technique described he

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

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

Jon Turner wrote:

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
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html






--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

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


"Jon Turner" wrote:

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