ipbr21054
Well-known Member
- Joined
- Nov 16, 2010
- Messages
- 5,689
- Office Version
- 2007
- Platform
- Windows
Morning,
On my command button I’m looking for it to copy a Textbox value on my userform & insert it into the stored code of which is then placed into another textbox.
Example,
Textbox1 has the value NEW
The command button will have a default string of HAPPY?YEAR
Basically the ? Is where the textbox value should be placed.
The code will then be placed into Textbox2
I plan to use this code on other command buttons BUT some will have characters as the stored code.
Example of stored code.
ABC@&?
Textbox4 has the value Z46
So the text Z46 is added to the stored code so when placed in the Textbox it will be ABC@&Z46
On my command button I’m looking for it to copy a Textbox value on my userform & insert it into the stored code of which is then placed into another textbox.
Example,
Textbox1 has the value NEW
The command button will have a default string of HAPPY?YEAR
Basically the ? Is where the textbox value should be placed.
The code will then be placed into Textbox2
I plan to use this code on other command buttons BUT some will have characters as the stored code.
Example of stored code.
ABC@&?
Textbox4 has the value Z46
So the text Z46 is added to the stored code so when placed in the Textbox it will be ABC@&Z46