Set No Focus in Userform Multipage Change Event

[liquidmettle]

Hi Everyone,

I have a userform that I recently added a multipage to by client request (to split up the fields in a more organized fashion).

I have quite a few textboxes that launch a calendar date picker when entered or selected.

The problem is this: When a user changes pages within the multipage, the date-picker launches if there are only date-picker enabled textboxes on that page.

I don't really want the calendar to launch simply because the multipage selects the first textbox it can.

Is there a way to set a "no focus" so nothing will be selected until the user does? I know I could add a random textbox or control and set focus to that but I'd really like to avoid that if there is another way.

Thanks!

[Bernie Deitrick]

Create a Global Boolean boolPC (booleanPageChange)

Then in the multi-page, use

Please Login or Register  to view this content.

And at the top of every Enter event

Please Login or Register  to view this content.

[liquidmettle]

Hi Bernie,

When declaring the Global Variable, do I put the following outside all functions on the userform?

Please Login or Register  to view this content.

[Bernie Deitrick]

Sorry - the parenthetical section was a remark.

At the top of a standard codemodule (I'm not sure if userform declarations are truly Global or not, but I am sure that codemodule declarations are):

Public boolPC As Boolean

[liquidmettle]

Hi Bernie,

No worries! Usually if I'm unsure I'll try what was verbatim first : p.

Global Variable Set, Multipage Change event set, added the boolPC if statement to all enter events...and have partial success : /.

Here's what I'm seeing:

In Page 1, there are other textboxes not associated with the calendar, so this page loads fine.

In Page 2 & 3, there are only "Enter-Event" textboxes, no other interact-able controls.

On the first selection of either Page 2 or 3, the calendar form still loads. However, this only happens once (which is a major improvement) instead of every time I switched between the tabs.

Thoughts?

Could it be that the boolPc variable is not being declared fast enough to register upon switching tabs?

[Bernie Deitrick]

It could be the order of the events, which I did not investigate. Try setting boolPC to TRUE in the userform initialize event, and maybe in the Mulitpage's Enter event

Please Login or Register  to view this content.

[liquidmettle]

Ah Bernie! Great Success!

Adding your last post cleared the calendar from loading in in Page 2, and making sure I also had boolpc=true under the change event removed it from loading from both.

It makes it so I'll have to explain that they'll have to click out of hte box before they can re-"enter" it to pull up the calendar form, but this is much better than it initializing on its own.

Thank you for your extremely fast assistance!