Data transferred automatically from one Userform to another Userform VBA - possible?

[newbi004]

Hi

I don't know if this is possible.

I have a Userform1 which has a commandbutton to open Userform2 on click. Userform1 also has a textbox.

Userform2 has a number of commandbuttons with different captions, say Item A, Item B, Item C and so on.

What I want to happen is :

1 Open Userform1
2 The textbox on Userform1 is empty
3 Open Userform2 on clicking the commandbutton on Userform1
4 When a commandbutton on Userform2 is clicked, the textbox on Userform1 is populated with the caption text of the clicked commandbutton.

I can do everything up to 3 above, but can someone start me off to do 4?

Many thanks

[millz]

Try this sample

[newbi004]

Thanks Millz. Simple and concise!