ActiveX TextBox

[pamai]

How do I make the Enter Key triger the macro once I hit enter after writing a word in Activex TextBox1 in excel 2007. Activex TextBox1 is = A1. When i hit Enter i want the macro that i have prepared to run provided that the text box has a word.

Any help will be appreciated! Thanks in advance

[pamai]

How do I make the Enter Key triger the macro once I hit enter after writing a word in Activex TextBox1 in excel 2007. Activex TextBox1 is = A1. When i hit Enter i want the macro that i have prepared to run provided that the text box has a word.

Any help will be appreciated! Thanks in advance

Please please help!

[Erayd]

This is a New Zealand forum, most people are in bed at this hour. We live in a +12 timezone.

If you wait a few hours you're more likely to get a decent response.

[pamai]

This is a New Zealand forum, most people are in bed at this hour. We live in a +12 timezone.

If you wait a few hours you're more likely to get a decent response.

Thank you - that itself is very helpful...I'll wait.

[pamai]

When do people wake up there?

[pamai]

'm still waiting for decent response!

[nofam]

Can I suggest you post your question on the MrExcel forum here if you require a faster response in your timezone?

[pamai]

Can I suggest you post your question on the MrExcel forum here if you require a faster response in your timezone?

Please help...i dont have access to certain site...so i need help. Thanks

[GameJunkie]

then join up to the forum in nofam's link