Textbox Events

Hello, i don't know where the code is wrong or placed this code in wrong event. I just want in the "Update Existing" tab, when i input a data in "Quote Number" field and press enter the code will trigger, and when i erase the data that I input in "Quote Number" field, all the data in the fields will be erase also.

Please Login or Register  to view this content.

Can anyone lend me a hand on this please?

Could anyone help me on this?

Goodmorining all!, can anyone help me on this?

Please Login or Register  to view this content.

Hi Alphafrog, thanks!, but still when i try to input a data in "Quote number" field without pressing enter, all fields has been populated.

I just want to populate the fields once I press enter.

When you press enter, you exit the textbox. Use the _Exit event trigger.

I've move the code to Exit event, but when i press enter, there's nothing happen...

Please Login or Register  to view this content.

Use the _AfterUpdate event instead.

Also, use this to look for an exact quote number match.

Set c = .Find(strFind, LookIn:=xlValues, LookAt:=xlWhole)

You saved my day again Alpha! Thank youuu sooo muuchh!

By the way could you try to run the below file. When i try to run the macro, it seems like it's slow or hang? the userform where replicated to many when i try to drag it somewhere.

I've also attached the screenshot.

In the TextBox14_AfterUpdate procedure, you turn off screen updating but you don't turn it back on. Add this to the end of the procedure.
Application.ScreenUpdating = True

Or better yet, don't turn off screen updating in that procedure. It's only useful when you write the data to the worksheet with CommandButton2 and you already toggle screen updating in that procedure.

Hi Alpha, i just want the userform stay in Sheet3, that's why i set screen updating to false. Is there any solution for that?

One has nothing to do with the other.

Don't select Sheet1. It's not required.

Delete these lines
Application.ScreenUpdating = 0
Sheet1.Visible = True
Sheet1.Activate

And this one.
c.Select

You may have other lines to clean up. I didn't check all the code. But again, you don't have to select sheet1 or cells on sheet1. You can write to it without selecting it.

Did you write this code?

Actually it's from RoyUK sample database. I've modified and add something to looks like the same what i want.

How do i select the quote number that i want to update and overwrite the data that i want? I'm having trouble in "Update" Button.

*****up*****

Anyone could help me with update button and search (textbox event) for the above attachment?