Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > microsoft.public.excel.programming > #108102
| From | "Robert Crandal" <noreply2me@yahoo.com> |
|---|---|
| Newsgroups | microsoft.public.excel.programming |
| References | <BZKdnQfQ355JNYPLnZ2dnUVZ5uCdnZ2d@giganews.com> <mvm9pt$ag5$1@dont-email.me> <EpWdnXf5Wa8x4oLLnZ2dnUVZ5qCdnZ2d@giganews.com> <mvnvk7$a7t$1@dont-email.me> |
| Subject | Re: Date picker on a form? |
| Date | 2015-10-15 05:14 -0700 |
| Message-ID | <oISdnWNiU-QuBYLLnZ2dnUVZ5sydnZ2d@giganews.com> (permalink) |
"Claus Busch" <claus_busch@t-online.de> wrote:
>
> please look again in the Office folder for OfficeXX\MSCAL.OCX
> where XX is the version number.
>
Okay, I will check later today if I can find "mscal.ocx" on our computer.
I don't understand why the calendar control isn't automatically available
in the Control toolbox. Even when I check "Additional Controls", it's
nowhere
to be found.
If I do find "mscal.ocx" in my file system, how do I install that into Excel
2013?
>
> If the users cannot write the date into the sheet use a text box and
> write the value to the sheet with e.g.
> Range("A1")=CDate(TextBox1.value)
>
The user will be presented with a UserForm that contains textboxes
and other controls (or a Calendar control if I can find and install it).
Once a valid date is entered onto the form, I plan to save that date
value in a variable. The date will not be outputted onto the sheet at all.
Back to microsoft.public.excel.programming | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread
Date picker on a form? "Robert Crandal" <noreply2me@yahoo.com> - 2015-10-14 12:11 -0700
Re: Date picker on a form? Claus Busch <claus_busch@t-online.de> - 2015-10-14 21:20 +0200
Re: Date picker on a form? "Robert Crandal" <noreply2me@yahoo.com> - 2015-10-15 03:27 -0700
Re: Date picker on a form? Claus Busch <claus_busch@t-online.de> - 2015-10-15 12:38 +0200
Re: Date picker on a form? "Robert Crandal" <noreply2me@yahoo.com> - 2015-10-15 05:14 -0700
Re: Date picker on a form? Claus Busch <claus_busch@t-online.de> - 2015-10-15 14:38 +0200
Re: Date picker on a form? "Robert Crandal" <noreply2me@yahoo.com> - 2015-10-18 01:07 -0700
Re: Date picker on a form? Claus Busch <claus_busch@t-online.de> - 2015-10-18 13:39 +0200
Re: Date picker on a form? "Robert Crandal" <noreply2me@yahoo.com> - 2015-10-19 09:49 -0700
Re: Date picker on a form? Claus Busch <claus_busch@t-online.de> - 2015-10-19 19:00 +0200
Re: Date picker on a form? Claus Busch <claus_busch@t-online.de> - 2015-10-15 15:40 +0200
Re: Date picker on a form? isabelle <i@v.invalid> - 2015-10-16 20:20 -0400
Re: Date picker on a form? isabelle <i@v.invalid> - 2015-10-16 20:46 -0400
csiph-web