Copy Data from Textbox to another sheet in the same workbook in real time without any command button

[shreyas17]

Hi Maters,

I am trying to work on a piece of work that requires me to copy data from a textbox in a form automatically to another sheet. However, the problem that I am facing is each time I change the value I have to run the code again for the value to change again in the other sheet. I need it to be done automatically in real-time.

Kindly help.

Kind Regards,

 

[DanteAmor]

Hi and welcome to MrExcel

What kind of textbox is it?
It is activex control.
So create a name range on the other sheet, say mycell, in the textbox properties, in Linkedcell write mycell.
Whatever you put in the textbox, it will automatically be in the cell.

 

[shreyas17]

Hi and welcome to MrExcel

What kind of textbox is it?
It is activex control.
So create a name range on the other sheet, say mycell, in the textbox properties, in Linkedcell write mycell.
Whatever you put in the textbox, it will automatically be in the cell.


View attachment 43328

Hi,

Thank you for your time in providing this.

It is an active control text box and as I enter a value in the text box, it should automatically enter the value in another sheet of a cell.

Hi and welcome to MrExcel

What kind of textbox is it?
It is activex control.
So create a name range on the other sheet, say mycell, in the textbox properties, in Linkedcell write mycell.
Whatever you put in the textbox, it will automatically be in the cell.


View attachment 43328

Hi,
Thank you for your time.

It is an activex Text Box.

Who are you speaking with today?

*

TextBox13

And when I enter anything in the TextBox13 , the value should be copied automatically to the cell D2 in real time . Like whatever change I make in the TextBox 13 will get automatically replicated in the cell.

 

[DanteAmor]

I don't understand everything you put in.
Did you do the steps that I put in post #2?

1. Select B2 cell
2. In name box enter mycell

3. Select textbox13
4. click right button to see the properties
5. In Linkedcell write mycell

6. Close the properties window

 

[shreyas17]

I don't understand everything you put in.
Did you do the steps that I put in post #2?

1. Select B2 cell
2. In name box enter mycell
View attachment 43350
3. Select textbox13
4. click right button to see the properties
5. In Linkedcell write mycell

View attachment 43351
6. Close the properties window

I was able to get it done.. Thank you so much

 

[DanteAmor]

Im glad to help you. Thanks for the feedback.