Typing the dates into a textbox is different from using a popup calendar.

John didn't include anything to do with the calendar control.

But if you wanted to type in the date, you could use 3 separate
textboxes--month, day, year.

Leanne M (Aussie) wrote:

I guess but I just left it as John said he tried all sorts and could not
change it.

It is only because I am in the UK and we display the days differently to the
US.

ie we display day/mth/year
--
Leanne M (Aussie)
(Changed Display name from Leanne)
United Kingdom
(Don''t ask me what an Aussie is doing living in the UK!)

"Dave Peterson" wrote:

If you're having trouble getting dates with John's enhanced userform (not John's
fault--that's the way excel works!), maybe you could modify his code to include
a calendar control (instead of a textbox???).

http://www.rondebruin.nl/calendar.htm
From Ron de Bruin's site.

Leanne M (Aussie) wrote:

Indeed it is unfortunate - any help I can get with this project is a god send.
--
Leanne M (Aussie)
(Changed Display name from Leanne)
United Kingdom
(Don''t ask me what an Aussie is doing living in the UK!)

"Gord Dibben" wrote:

Thanks for letting us know the outcome.

Unfortunate.


Gord

On Thu, 24 Apr 2008 07:19:01 -0700, Leanne
wrote:

I have already emailed John and he can not resolve the data issue for me so
there is no point as I can not use the form.

"Gord Dibben" wrote:

Pay John the 20 bucks for the source code and edit as you wish.


Gord Dibben MS Excel MVP

On Tue, 22 Apr 2008 07:22:05 -0700, Leanne
wrote:

HI,

I have downloaded the above form and customised it following the instructions.

I have one question that I hope someone can answer.

Is there any way (macro, vba code, anything) I can disable the New/Insert
button. I only want to use this form for editing existing records.

Can anyone help?
Thanks





--

Dave Peterson


--

Dave Peterson