a on_doubleclick statement is not working

[filo666]

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

[Rowan Drummond]

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

[filo666]

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
>

[Rowan Drummond]

You're welcome.

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