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

Public variables should be declared in a standard module. The modules
for sheets and forms are Class Modules. Try moving:
public valuex as string
to a standard module.

Hope this helps
Rowan

filo666 wrote:
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

Thank you very much, it works as expected

"Rowan Drummond" wrote:

Public variables should be declared in a standard module. The modules
for sheets and forms are Class Modules. Try moving:
public valuex as string
to a standard module.

Hope this helps
Rowan

filo666 wrote:
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

You're welcome.

filo666 wrote:
Thank you very much, it works as expected