User Form and Tab Orders Irrelevant

**00Able** · 11-28-2010, 08:11 PM

Ok, because I added a calendar to a userform, I had to change the tab order, so it doesnt initiate the calendar; however, because I switched the tab order around, after you press submit the calendar appears and it is confusing as to what step is next, Any suggestions on how to straiten this out, so it works and looks proper?

**davesexcel** · 11-28-2010, 08:25 PM

You can go to the view menu to set the tab order, you should be able to set focus to the next control after making a selection in your calendar.

**royUK** · 11-29-2010, 02:16 AM

Not sure why the Tab order is a problem. I've set the Date box to be the last object tabbed to. Seems to work fine

**00Able** · 11-30-2010, 05:21 PM

I have found my problem I had code that read:

Please Login or Register  to view this content.

and should have read

Please Login or Register  to view this content.

so the Calendar would not pop up imediately after you press submit, I rearranged the Tabs on the actual form as well as order, and now all looks and acts right.

Thanks for all of your assistance, I would not have been able to do this without your help.