Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Mark
 
Posts: n/a
Default Creating a Date Selector in Excel VBA?

check out my calendars at:

http://au.geocities.com/windsofmark



However, if you want an Excel-based Calendar and schedule
list, then send the info to me and I will create it.

see my excel stuff at:
http://www.geocities.com/excelmarksway




- -Mark

-----Original Message-----

I'm trying to create a spreadsheet that allows you to

define maintenance
schedules for lanscape management work.

The items that are going to be in the maintenance

schedule generally
occur yearly (e.g. turf refurbishment) or monthly (e.g.

litter
collection, grass cutting).

I want to be able to have a dialog box appear that allows

the user to
specify for the yearly items what date of the year

maintenance occurs
(dd/mm/yyyy) or for the monthly items what date of the

month
maintenance occurs (dd/mm).

Does anyone have any ideas about how best to achieve

this? I thought
about have 3 textboxes with spinnerbuttons bound to them

so the user
can create their own dates by selected the dd/mm/yyyy

components
seperately, or maybe 3 drop down lists that do the same

thing.

However.......if I did this, how would I stop dates being

created that
don't actually exist? E.g. 30th February, 31st September

etc?

I suppose I could write an error handling routine for

each month
selected and check to see if the days selected for that

month fall
within an acceptable range e.g. range for September would

be:

Range
Septmember_Days = 1
September_Days < 31

The user would need to click an 'OK' button once they

have the date
entered as they want it, and then the date from the

textboxes is passed
to a variable, or perhaps stored in a cell somewhere.

Whatever, as long
as it's retrievable later on in the application.

But is there a better way of doing this? I would have

thought Excel
would have some kind of built-in calandar type function

to do this sort
of thing but I can't seem to locate it if it does.

Cheers
-Rob


--
TheRobsterUK
----------------------------------------------------------

--------------
TheRobsterUK's Profile:

http://www.excelforum.com/member.php?
action=getinfo&userid=9924
View this thread:

http://www.excelforum.com/showthread...hreadid=320436

.

Reply
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 updates from worksheet to chart & changes date to a date series! Help!! Jayjg Charts and Charting in Excel 2 January 22nd 05 04:00 PM
Creating GIFs in Excel 2003 for use in Dreamweaver Lou Crandall Charts and Charting in Excel 2 January 2nd 05 08:58 PM
Charting Data from Excel DavidM Charts and Charting in Excel 4 December 30th 04 03:31 PM
Auto date changing in Excel is maddening brhicks Charts and Charting in Excel 3 December 16th 04 03:54 PM
Ignoring characters in excel sheets when creating a chart smintey Charts and Charting in Excel 2 December 7th 04 07:17 PM


All times are GMT +1. The time now is 06:24 PM.

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

About Us

"It's about Microsoft Excel"