Userforms / Coping Into Sheets

[Rusty]

If I create a user form with 3 text input boxes and a confirmation button.

What is the script to do this:

Contents of text box 1 pasted to cell ‘A1’
Contents of text box 2 pasted to cell ‘B1’
Contents of text box 3 pasted to cell ‘C1’

Thanks.
Apologies for such a stupid question

[Ivan F Moala]

On 2002-04-16 03:44, Rusty wrote:
If I create a user form with 3 text input boxes and a confirmation button.

What is the script to do this:

Contents of text box 1 pasted to cell ‘A1’
Contents of text box 2 pasted to cell ‘B1’
Contents of text box 3 pasted to cell ‘C1’

Thanks.
Apologies for such a stupid question

Not a stupid Q...try

[A1]=textbox1:[B1]=textbox2:[C1]=textbox3

[Rusty]

Ivan,

So simple and yet so true.... :0

I was wrapping myself up in too many lines of script.... oh the embarrasment

[Rusty]

Ivan,

So simple and yet so true.... Thanks
I was wrapping myself up in too many lines of script.... oh the embarrasment