now that i got the posting to work
 

okay..now i know how to take text content and add it to cells.

i need the Sheets("blah").Range("A1") to change cells to the next row.
how would i go about doing that?

in other words...i need it to write to cell A1, then A2 the next time
enter is pushed, A3, the third time, etc...

thanks!
john

now that i got the posting to work
 

If "blah" is your active sheet and Cell A1 is the active cell and starting
point, then you may try using:

ActiveCell.Value = "text"
ActiveCell.Offset(1, 0).Select

If you always want the next empty cell in column A, then you may try
something like:

ActiveSheet.Range("A65536").End(xlUp).Offset(1, 0).Select

HTH,
Paul


"unclescrooge" wrote in message
ups.com...
okay..now i know how to take text content and add it to cells.

i need the Sheets("blah").Range("A1") to change cells to the next row.
how would i go about doing that?

in other words...i need it to write to cell A1, then A2 the next time
enter is pushed, A3, the third time, etc...

thanks!
john

now that i got the posting to work
 

On Mar 6, 11:54 am, "PCLIVE" wrote:
If "blah" is your active sheet and Cell A1 is the active cell and starting
point, then you may try using:

ActiveCell.Value = "text"
ActiveCell.Offset(1, 0).Select

If you always want the next empty cell in column A, then you may try
something like:

ActiveSheet.Range("A65536").End(xlUp).Offset(1, 0).Select

HTH,
Paul

"unclescrooge" wrote in message

ups.com...



okay..now i know how to take text content and add it to cells.

i need the Sheets("blah").Range("A1") to change cells to the next row.
how would i go about doing that?

in other words...i need it to write to cell A1, then A2 the next time
enter is pushed, A3, the third time, etc...

thanks!
john- Hide quoted text -

- Show quoted text -

Hi Paul,

Thanks, just so I'm clear...

after the Sheets("blah").Range("A1") = textbox.Value

i would add the

ActiveCell.Value = "text"
ActiveCell.Offset(1, 0).Select

portion to the coding?

thank you again!
john

now that i got the posting to work
 

Try this:

Sheets("blah").Range("A" & ActiveCell.row + 1).Select
Selection = textbox.Value



"unclescrooge" wrote in message
ups.com...
On Mar 6, 11:54 am, "PCLIVE" wrote:
If "blah" is your active sheet and Cell A1 is the active cell and
starting
point, then you may try using:

ActiveCell.Value = "text"
ActiveCell.Offset(1, 0).Select

If you always want the next empty cell in column A, then you may try
something like:

ActiveSheet.Range("A65536").End(xlUp).Offset(1, 0).Select

HTH,
Paul

"unclescrooge" wrote in message

ups.com...



okay..now i know how to take text content and add it to cells.

i need the Sheets("blah").Range("A1") to change cells to the next row.
how would i go about doing that?

in other words...i need it to write to cell A1, then A2 the next time
enter is pushed, A3, the third time, etc...

thanks!
john- Hide quoted text -

- Show quoted text -

Hi Paul,

Thanks, just so I'm clear...

after the Sheets("blah").Range("A1") = textbox.Value

i would add the

ActiveCell.Value = "text"
ActiveCell.Offset(1, 0).Select

portion to the coding?

thank you again!
john