This is my first post, so please bear with me. I am trying to finish up my first UserForm ever. Workbook is attached since I cannot really pinpoint what may be causing my SetFocus in the Private Sub txtde30_AfterUpdate() to not work properly. I have other setfocus statements within other subs that are working ok.
This is a MultiPage User From. I have an If statement where when true, execute some code, then I want to set focus back to a text box on that page after the text boxes were cleared. It keeps going to the next command box control instead.
I have tried _Change() ,_Exit(ByVal Cancel As MSForms.ReturnBoolean), _BeforeUpdate(ByVal Cancel As MSForms.ReturnBoolean). Some of these ended up goofing up clearing the text boxes, some just kept going to the next command box.
I realize this code overall is not the best written, but it is working well for everything I want except this one setfocus.
Thank you for any assistance you can give.
P.S. The only choices for the dropdown boxes on the Summary page that are built are for Distribution. Others are under construction.
Bookmarks