Hi,

Another enhancement would be to hide the combobox when the workbook opens :)
--
http://blog.jausovec.net


"MartinShort" wrote:


I've made a slight enhancement to Peter's code which will hide the combo
unless you've selected a cell in the column11.
Code:
--------------------
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Column = 11 Then
ComboBox1.Visible = True
ActiveSheet.Shapes("Combobox1").Left = Target.Left
ActiveSheet.Shapes("Combobox1").Top = Target.Top
Else
ComboBox1.Visible = False
End If
End Sub
--------------------


--
MartinShort

Software Tester
------------------------------------------------------------------------
MartinShort's Profile: http://www.excelforum.com/member.php...o&userid=22034
View this thread: http://www.excelforum.com/showthread...hreadid=376700