LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default Date entry in userform help

You just put the code in the events of the spin buttons to increment the
value in the textbox. A special control for this function may exist, but
it is very straight forward using just a textbox and a spin button or three
textboxes and three spin buttons if you want to control month day and year
separately - you could have three spin buttons and a single textbox, but I
think that would be more confusing to the user.

If you want a sample workbook, send me an email with a valid email return
address.

--
Regards,
Tom Ogilvy



bmwmcrider wrote in message
...
Hi Steve,

Thanks for the reply. I am already familiar with the Calendar control;
there is also a MonthView control for entering a date.

However, both these controls take up a lot of space in the form. I am
trying to get a more compact control presentation for entering a date.
Thus, the TextBox control concept.

Mike




*** Sent via Developersdex
http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Date Format for Userform TextBox John Calder New Users to Excel 4 July 29th 09 10:19 PM
Excel 2002 date entry: Cannot get away from d-m-yy entry format Steve Eklund Excel Discussion (Misc queries) 3 May 11th 09 04:57 PM
userform date issue Woodi2 Excel Worksheet Functions 4 February 7th 09 02:18 PM
Restrict date format for UserForm Rob Excel Discussion (Misc queries) 2 December 19th 05 12:13 AM
Userform Date validation David Goodall Excel Programming 6 August 19th 03 11:46 PM


All times are GMT +1. The time now is 10:47 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"