Is there any way to control the format in UserForm controls (like
there is in cells) to accomplish a WYSIWYG setup?
The "problem" is like this; I set up a combobox on a form to select a
date in mm/dd/yy format - the data comes from a range of cells
formatted to show dates ("TODAY()", TODAY+1", etc.) formatted as
"mm/dd/yy" & the cell the selection is written to is also formatted
the same...yet the ComboBox on the form shows the 5-digit Excel date
code until the focus shifts off the ComboBox, then shows the form
mm/dd/yyyy (& additionally drops preceeding zeroes) - even though the
format is correct in the destination cell once the UserForm is closed.
What I'm trying to avoid is confusion in the minds of some of the
folks who will be using this workbook...not all of them are especially
bright nor computer-literate. TIA.

tm