Q: use _ENTER event

[DJ FastEddy]

Hi,

I have a UserForm with some textboxes. I want to enter text in TextBox1 and on <Enter> a subroutine must be activated to fill in all the other textboxes. I have done a test setup how it works but only after I entered through all the TextBoxes they are filled with the data.

This is my test setup. If I got the basics working I'll can figure out the rest what I want to do.

Private Sub TextBox1_Enter()

TextBox2 = TextBox1
TextBox3 = TextBox1
TextBox4 = TextBox1

End Sub

All the TextBoxes are on the same UserFrom. In a later stage these TextBoxes will be filled with data from worksheets.

I anyone can give me a hand with this it's much appreciated.

Thanx

Edwin.

 

[DominicB]

Good morning DJ FastEddy

I personally would be tempted to use the TextBox1_Exit event - then the other textboxes are filled in when you tab, enter or click out of the box. Slight amendment to your supplied code :

Private Sub TextBox1_Exit(ByVal Cancel As MSForms.ReturnBoolean)
TextBox2.Value = TextBox1.Value
TextBox3.Value = TextBox1.Value
TextBox4.Value = TextBox1.Value
End Sub

HTH

DominicB

EDIT : BTW, the TextBox1_Enter event is fired when you actually enter the textbox, not when you press enter from the textbox.

 

[DJ FastEddy]

Thanks Dominic,

That's what I was looking for. I have the English version of an Excel programming guide and it didn't explain clearly the differen between Enter and the use of the button <ENTER>.

It works now as I wanted.

Can you explain what this part in your code means: (ByVal Cancel As MSForms.ReturnBoolean).

Thanks again,

Edwin.