Want calendar widget to popup on click and NOT tab into a cell

[xdrenched]

Hi,

We have a calendar widget that pops up for all date fields formatted mm/dd/yyyy using VBA. Is it possible to have it only pop up when users click in the date cell, and NOT pop up when users tab into the date cell?

Thanks!

[Tinbendr]

You likely have a Change event on the sheet code page in question that initiates the calendar widget. Using the dropdown on the upper right of the code page, select the Dbl-Click event. This will add the event code to the page. (You can manually type it in, too.) Then, copy the code into there.

[xdrenched]

Thanks! Is it possible to enable pop ups on a single click, but not a tab? Folks will be doing a high volume of data entry and double click will probably annoy them. I know it's currently using "selection change" but is there some sort of "on click" option?

[Tinbendr]

There is a BeforeRightClick event that might suit your needs.

[xdrenched]

You know, I also looked into right click, but I think it will be confusing for folks since it also brings up the right click menu at the same time as the widget. I'm really just looking for a single left click event. The answer might be that it isn't possible to have that without a tab event as well, but I was just hoping there was an option I didn't know about! Thanks!