Hi There.
I am trying to transfer the text in a cell over to a user form textbox but it replaces the cell with the text and overwrites the formula.
The TextBox control source is blank and the following code is in the TextBox Change event.
This code simply overwrites the formula after it changes the textbox. any ideas?
Please Login or Register to view this content.
Your backslash [\code] needs to be changed to a forward (/) slash
Your code says that if you do change something in the textbox (TextBox1_Change()), whatever is in the textbox should be put in Cell Z2.
You ask for the other way around, is that right. How do you want this to do that? When the Userform opens (initialize)?
The value of Cell Z2 will be in TextBox1 when you open the Userform.
Please Login or Register to view this content.
Last edited by jolivanes; 09-01-2016 at 05:24 PM.
Hi Jolivanes.
Yeah saw my mistake and edited it 2 seconds later. .../...
I am trying to populate the TextBox from Cell "Z2" without overwriting the formula that is in cell "Z2"
Perhaps I shouldn't be using a textbox as I am not wanting to have text entered into it.
The code I gave you will populate the textbox on the userform with the value, not the formula, from cell Z2 as soon as you open the userform.
If you want it done differently, you have to let us know.
Have you tied the code?
Awesome Jolivanes.
I now see that this has to happen on the initialise event and not in the textbox change event.
It works great and now when the cell changes due to the formula calculating it also changes on the UserForm.
The answer to my thread is ' your code must be put in the "UserForm_Initialize()" event
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks