How to Cancel ComboBox Dropdown
I am using Office/Word 2010. I'm not allowed to bring in the calendar control for a userform I've created that needs a date picker. I am trying to simulate the date picker as closely as I can. The real date control looks like a combobox. When the button on the right with the down arrow is pressed the calendar pops up for the user to pick a date.
I had the (seemingly) bright idea of replacing it with a combo box and showing my custom date picker calendar when the drop down button was pressed.
So far, so good. The problem is that the empty drop down is showing after my date is picked. I tried a Sendkeys {Esc}. {Enter}, etc. but that didn't work.
The over idea is to put a downward pointing triangle on a button, but I don't have such an icon and it seems this will work fine if I could only get the list to retract.
|