AfterUpdate/BeforeUpdate and SetFocus

**odekkers** · 05-05-2010, 12:44 PM

I have some problems with the SetFocus command in a Userform with an AfterUpdate or BeforeUpdate routine.

To make it clear to you, I made a very small Userform to demonstrate it. It only contains 8 TextBoxes and this code:

Please Login or Register  to view this content.

I expected that in all cases, the focus should be set to TextBox08, but this only happens with the Change event.

Do you have any suggestions how I can set the focus to TextBox08 in an AfterUpdate or BeforeUpdate event?

I use Excel 2007

Kind regards,

Otto.

**Leith Ross** · 05-05-2010, 01:03 PM

Hello odekkers,

Welcome to the Forum!

As a new member of the forum, please take a few minutes and read the forum rules for posting and general etiquette. To see them, click on the link below...

Forum Rules

**Leith Ross** · 05-05-2010, 01:38 PM

Hello Otto,

Try this trick, it works in Excel 2003...

Please Login or Register  to view this content.

**odekkers** · 05-05-2010, 03:32 PM

Hello Leith,

Thank you for helping me posting mu question correctly, and for you quick answer. But I'm sorry, your trick didn't make any difference.

Kind regards,
Otto.