reposition combo box **
Depending on where you got the control from, one of these
Worksheet_SelectionChange event code should do what you want...
For Forms Toolbar Drop Down Control
===================================
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
With ActiveSheet.Shapes("Drop Down 5")
.Top = Target.Top + Target.Cells.Height
.Left = Target.Left
End With
End Sub
For ActiveX ComboBox Control
===================================
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
With ActiveSheet.ComboBox1
.Top = Target.Top + Target.Cells.Height
.Left = Target.Left
End With
End Sub
Rick
"Atishoo" wrote in message
...
does anyone know how to make a combo box position itself close to the
active
cell each time a cell is selected??
have tried a few ideas but they all seem to take forever to execute in VBA
|