Using (Chr$(13)) to submit data in a TextBox (SOLVED)

[phantom1975]

I tried this and it won't work:

Private Sub TextBox1_Change()
Application.Onkey "{ENTER}" Or "~","Macro1"
End Sub

Basically, after the user enters data into the TextBox and hits the either ENTER key, I want to run Macro1.

What should I do instead?


_________________
Pass on what you have learned. Support this great website by clicking on the sponsor's ads!.
This message was edited by phantom1975 on 2002-08-22 23:38
This message was edited by phantom1975 on 2002-08-23 01:20

 

[Ivan F Moala]

On 2002-08-23 01:20, phantom1975 wrote:
I just found what I am looking for!

Private Sub TextBox1_KeyDown()

If Keycode = 13 Then
Unload Me
UserForm2.Show
End Sub

Shouldn't that be ??
<pre/>
Private Sub TextBox1_KeyDown(ByVal KeyCode As MSForms.ReturnInteger, ByVal Shift As Integer)

End Sub
</pre>

 

[phantom1975]

Yes, it is. I am doing my code on my laptop and my questioning on my home computer. Can't dial up with my laptop. I was just too lazy to type the whole thing out! Thanks for catching it Ivan!