Greetings,
Can someone please assist me in doing the following.
I have a Text Box on my worksheet that has an OnAction macro assigned to it. The text in this textbox is in the following format (PART NAME & Chr(10) & PART NUMBER):
MOTOR
12345-678
When the Text Box is clicked, it will open up UserForm1. UserForm1 has 2 textboxes, PartName and PartNo.
I would like to pull the first line of the Text Box text into PartName and the 2nd line into PartNo.
How do I write code to pull everything up to the Chr(10) and place it into PartName and then take everything after that point and place it into PartNo?
Any assistance would be appreciated. Thanks!
Can someone please assist me in doing the following.
I have a Text Box on my worksheet that has an OnAction macro assigned to it. The text in this textbox is in the following format (PART NAME & Chr(10) & PART NUMBER):
MOTOR
12345-678
When the Text Box is clicked, it will open up UserForm1. UserForm1 has 2 textboxes, PartName and PartNo.
I would like to pull the first line of the Text Box text into PartName and the 2nd line into PartNo.
How do I write code to pull everything up to the Chr(10) and place it into PartName and then take everything after that point and place it into PartNo?
Any assistance would be appreciated. Thanks!