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