I have 2 issues to resolve.
I have a UserForm that is initialized. I want the userform to show then go to textbox1 and highlight the text for editing. (The cursor defaults to the end of the text). I have that textbox populate from another worksheet.range but I want to set focus and highlight for easy editing.
Then next issue is that I have another text box on the same UserForm that populates from another worksheet.range and must be a numeric value. I am using a Public Function IntegerValidation(ByVal MyTextBox As Control) to check it's contents - This works fine, but I want it to highlight the text.value to easily edit it correctly if the enduser enters a non-numeric value.