Greetings, all.
Unsure if this question goes in this particular forum, but as this would involve a Save command button's macro I thought I would start here. No worries if it gets moved or recommended I post elsewhere.
Basically, I am trying to eliminate the chances of people making errors entering dates in a userform. Something like you see on web order forms with 3 adjacent pulldowns for the month/day/year. I've tried adding the legacy calendar to excel 2010, which works, but unfortunately it's a little large for the space of the userform, and I would like this to be easily used by any user across the office without me having to "patch" every individual system. So, I was wondering if there was a way I could take, for example, the "9" out of the month box, the "21" out of the day box and "2012" out of the year box and merge them into a single cell as "5/12/2012". I suppose I could just assign each vlaue to adjacent cells, but if possible I would like to keep it as easy to read as possible.
CHeers!
Bookmarks