run macro after 4 digits entered

**gopcs** · 09-21-2009, 09:45 AM

I have a macro that is used several times a day. Four digits are entered in cell E5, then I press Enter, then click on an icon that has a macro assigned to it. Is there a way to trigger the macro after simply entering the four digits? Or can the macro be triggered after entering the four digits then pressing Enter? Thanks in advance.

**sweep** · 09-21-2009, 10:59 AM

Hi,

This in the worksheet module:

Please Login or Register  to view this content.

will trigger the subroutine bob when cell E5 is changed.

**gopcs** · 09-21-2009, 02:57 PM

Thank you for the quick reply.
I must be doing something wrong. When I enter 4 digits in E5 and press Enter, nothing happens.

Please Login or Register  to view this content.

**NBVC** · 09-21-2009, 04:01 PM

The macro Dave gave you goes in the worksheet module... so you right-click the worksheet tab and select View Code, then paste his code there, in the VBE editor.