Thanks again Rick, I just want to be able to open up the sheet and pick a
date that will print on the form.

"Rick Rothstein" wrote:

Well, you have to write VB event code to make it do something in response to
the user's actions. We can try and give you some code to get you started,
but if you are not a programmer, then you will probably be stuck with
whatever code the volunteers here in this newsgroup can write for. Exactly
how did you want it and user to interact?

--
Rick (MVP - Excel)


"Canon" wrote in message
...
Thanks Rick, I have it on my sheet now, but how do I make it work?

"Rick Rothstein" wrote:

Yes. First off, do you have the Developer Tab showing on your Ribbon? If
not, click the Office Button (large round icon in upper left corner of
Excel), click the Excel Options button at the bottom of the dialog that
displays, click the Popular item in the left-hand list and put a check
mark
in the "Show Developer tab in the Ribbon" check box. Okay, now click the
Developer Tab and then click the Insert icon on the Controls tab, then
click
the "More Controls" icon in the bottom right corner of the ActiveX
Controls
section and find "Microsoft Date and Time Picker Control 6.0" in the
list,
select it and click the OK button and draw the control onto the
worksheet.

--
Rick (MVP - Excel)


"Canon" wrote in message
...
Excel 2007
Can I insert a "Date Picker" in Excel like you can in Word?