dropdown class greyed out

[pb21]

I would like to create a dropdown list in each cell that is only visible on double click. if i look in the object browser for dropdown class it is greyed out how do i get it to use.
regards

peter

 

[HaHoBe]

Hi, Peter,

if you use the DropDown form Data/Validation it will always be visible if you select the cell. The DoubleClick should start a macro and fill the cell with a dropdown but I would prefer to start a userform instead of putting and clearing dropdowns in cells (frmPB21 is the name of that userform where a combobox would do the job):

Option Explicit

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Excel.Range, Cancel As Boolean)
If Intersect(Target, Range("b2:B100")) Is Nothing Then Exit Sub
frmPB21.Show
Cancel = True
End Sub

Ciao,
Holger