Re: Can a menu bar cause validation?
Try the SetFocus method for a control instead of SendKeys. Or you can change the focus via API.
Try evaluating objects with the Is operator instead of the equals sign.
BTW, top level menus have a click event too, so you can use one event to do the change in focus for all the items in that menu's list. You could also make a sub to pass focus, and simply call it from whatever menu click events you need.
Please remember to rate the posts and threads that you find useful.
How can something be both new and improved at the same time?