UserForm interaction and Doubleclick events

[Elvisman]

Hello,

I'm making a macro for printing with tray selections. The macro that I'm making is this far: all the sheetnames of the excel document get inserted into a ListBox. And then comes the following step:

When you doubleclick on the sheetname in the list, a new UserForm will open (that contains the sheetname and a combolist that contains 7 options of printers).

So question 1 is: how do you write an event that opens UserForm2 by clicking on an item in a listbox? (simple code please)

The next thing: I want the label in UserForm2 to contain the name of the doubleclicked item in the ListBox. I tried this:

Label1.Caption = CStr(ListBox1.List(i - 1))

It however doesn't work.

So question 2: How do I get the name of a ListItem from one userform to a label in another userform? (simple code please)

And my last question is: When I have a variable in a userform. How do I recall the variable from another userform? (Also simple code please)

I'm really hoping you could help me. I'm really stuck now...

Jeroen

[westconn1]

put in the click event for the listbox
userform2.show

normally you would use the click event of the list box, but in this case
put in the dblclick event
label1 = listbox1.text
or
userform3.label7 = listbox1.text

myvar = userform2.somevar
where somevar is defined in the general section at the top of userform2 as public

[Elvisman]

Thank you.

However , I tried the following event

Private Sub listbox1_dblclick()


End Sub

and also this one:

Private Sub listbox1_doubleclick()


End Sub

they both don't work.. How do I make the doubleclick event?

[westconn1]

you do not make it, select from the dropdown boxes at top of code pane of userform that contains listbox
listbox in left then event in right

Private Sub ListBox1_DblClick(ByVal Cancel As MSForms.ReturnBoolean)
Label1 = ListBox1.Text
 
End Sub