-
Mar 23rd, 2010, 11:42 AM
#1
Thread Starter
Junior Member
Excel VBA - SpinButton - 3rd Friday of every month
Hi,
I am trying to draw a spin button on a userform, in order to generate the date of the 3rd friday of each month that is after the current date (today). In order words, the coming 3rd friday will be the earliest date available.
For example, the date of every 3rd friday of the month will be shown with every incremental change of the spinbutton as below:
16/4/2010
21/5/2010
18/6/2010
16/7/2010
However, the 19/3/2010 should not be given since it has already over and on 17/4/2010, the earliest date will be replaced by 21/5/2010 as 16/4/2010 will become unavailable.
It would be great if you could help me up with this as i'm new to spin button. Should i predefine a list of date or is there any excel formula that can help to identify them?
Thank you
xwxc
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|