Add A text box to a work Sheet

[mechpm]

I would like to add three text boxes to a work sheet.
Were I would be able to enter data, press enter on the keyboard
and the data would appear in the next available cell
Example
Textbox 1 would return data to F9 and below

textbox 2 would return data to G9 and below

textbox 3 would return data to H9 and below

I am new to V B A However, I now how to get around somewhat (I’ve been playing with the ever so popular command button)
I can manage getting the text boxes onto the work sheet and I know
How and were to enter the code

If someone could help me with code?


Thx

RW

[Juan Pablo González]

Range("F65536").End(xlUp).Offset(1) = TextBox1


Repeat for the others with G and H, and TextBox2 and TextBox3

[mechpm]

On 2002-05-15 17:02, Juan Pablo G. wrote:
Range("F65536").End(xlUp).Offset(1) = TextBox1


Repeat for the others with G and H, and TextBox2 and TextBox3

THX JUAN
your solution did the trick

However, I’m afraid that I have not been specific enough,As I often do.




Our worksheet is an order form for wye and tee pipe fittings


The text boxes are labeled A, B, & C

Cell F7 is the header (size) F 8 is sub header (A) rows G & H are typical.




Example
Textbox 1 would return data to F9 and below
Textbox 2 would return data to G 9 and below
Textbox 3 would return data to H 9 and below


We would like to enter data in the text boxes, press enter,
were value would enter next empty cell and clear text box.

Also curser would move to text box B.and would repeat thru box c, were we could strat again. The range would be row 9 thru 25.


I have found some similar stuff in walkenbach book using excels dialog box.
However, I can’t get it to work.

I hope this will help you help us. We will keep reading to maybe find
A solution.










[ This Message was edited by: mechpm on 2002-05-15 19:54 ]