enter() event vs. mousedown() -- confusion

I am not sure what you mean, is there already text in the textbox?
What are they clicking? Clicking into the textbox?

Hi losmi8 - let me try an explanation.

Your code above is Behind TextBox1 which lives on your Userform. If you press Enter while in this TextBox, the code isn't fired because it only fires when you do a MouseDown while in that TextBox.

If you wanted something to happen when you pressed Enter anytime you were on the Userform, you'd have to put an On Enter() Event behind the Userform. Now that I look there is no Enter Event for a Userform. The events that are allowed for a control are on the right dropdown after selecting the object in the left dropdown above the VBA Code window. I don't see a Userform Close event so I search the list and see Deactivate. Press Help and read about Deactivate for a Userform. This has possibilities. You could save all text to Cells or Variables when the Userform Deactivates.

Another way to solve this problem is to look at the Properties of Each TextBox. The property of ControlSource is the important one. If you set that TextBox to a Cell it will show that Cells Value in the TextBox and change that Value when you change the TextBoxes text.

Simply put - Events only fire on the object you put the code behind.

A good source is http://www.cpearson.com/excel/Events.aspx for events
Another hint for learning. Click on the Textbox and then find ControlSource in the Properties of the TextBox window. Now Press F1 and see how it works. I see it can equal a String in the help file.

I hope all this helps and isn't just redundant for what you have already discovered.

Now that I did all that babble below. Look at the AutoWordSelect Property for the TextBox.

Click AutoWordSelect in the Properties window and Press F1.

I think this is what you want. All the stuff below may have missed the question.

I don't think I've explained myself very well. All I am trying to accomplish is the following:

When I click into a TextBox, I'd like whatever is in that TextBox to be Selected (as in Select All/Highlighted) so that when I hit a keystroke, everything that was in there will be replaced with this new keystroke.

I don't care about hitting Enter.

Also, is there way for me to do this for all of the TextBoxes by using "Set Focus" option? So if any TextBox is in focus, I call this sub somewhere that will highlight everything in that textbox?

Marvin - all of my textboxes have that setting set to "True" and I don't see what it does when I turn it off. I'm not sure of its property.

See what this does for you

Please Login or Register  to view this content.

Click on TextBox2 and the entire text should be selected

Hello losmi8,

To answer the second part of the your question, there is no built in method you can apply to all the TextBoxes. However, it is possible to create a common event handler that is shared among all the TextBox controls.

There are 3 parts to doing this. There are 2 Class modules. One module is for the TextBox event handling. The second creates a collection of individual event handlers and set references to each individual TextBox. Lastly, you need to add code to the form to add the TextBoxes to this collection.

NOTE: Each Class Module must be separate. The code can not be combined into a single module.

After adding the Class module, change the name in the Properties dialog to match the name in the header above the code. If you do not rename the modules, the code will not work.

TextBoxEvents

Please Login or Register  to view this content.

TextBoxObjects

Please Login or Register  to view this content.

UserForm Code

Please Login or Register  to view this content.