How to Add a datepicker in excel that works when sending it to others

Question

Ok. I have used the datepicker ActiveX with Excel 2007 a lot of times. On my computer it works very well. BUT when I sendt the excel sheet to others, a lot of them experience problems with the datepicker. Is there a way to fix this?

duplicate of [Formatting MM/DD/YYYY dates in textbox in VBA](http://stackoverflow.com/questions/12012206/formatting-mm-dd-yyyy-dates-in-textbox-in-vba). The other question is quite different, but the [answer by @Siddarth Rout](http://stackoverflow.com/a/12013961/14420) is correct for this one. — matt wilkie, Sep 30 '13 at 16:20

score 0 · Answer 1 · answered Feb 21 '12 at 18:13

0

You need to build the entire module into the Excel workbook. How-to

answered Feb 21 '12 at 18:13

PenguinCoder

4,335
1
26
37

How to Add a datepicker in excel that works when sending it to others

1 Answers1