Enter textbox value in next cell

Hi guys,

Is it possible to link content in a textbox to the adjacent cell?

Example: I enter the number "1" in a textbox (A1). Then I want the next cell on the right (A2) to display the number "1" as well. I want this to happen automatically as I enter the value in the textbox.

Thanks for your help!

Typo: A2 should be B1

Thank you for your reply!

I have a textbox in one cell and nothing in the other cell. I want the value i enter into the textbox to display in the cell that has nothing in it.

I need the code to be dynamic, so that wherever i put the textbox, the cell to the right of that textbox will have the same value as the textbox.

Works. Thank you!

Just one more question:

How do you get the macro to run automatically? I don't want the user to have to run the macro every time they enter a value in a textbox.

Thank you again!