Hi, could someone could tell me why this:
public valuex as string
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As
Boolean)
Application.ScreenUpdating = False
UserForm11.Show
Target.Value = valuex
Application.ScreenUpdating = True
End Sub

valuex =combobox3 (combobox3 on_change event)
and valuex appears as empty althought I declared it (public valuex as string)
I also trayed to declare valuex on my userform module
TIA