Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-03-2016, 05:18 AM
glda19 glda19 is offline Calendar for holidays Windows XP Calendar for holidays Office 2010 32bit
Novice
Calendar for holidays
 
Join Date: Apr 2011
Posts: 5
glda19 is on a distinguished road
Default Calendar for holidays

Hi
That is a callender that is not made by me.


What i whant is that callender is made by vba because now there are to many formulars.
And not so much conditional formatating ruels.
and look verry good at the red thik lines on the year 2015 2016 2016
Example when the last red line is between week 51 and 52 off 2016. Then is week 52 the first week of the blok of 4 for 2017 so the red thik line is between 2 and 3
when here are to weeknumbers the same with a blanck colum between ore not only a red line after the secound weekniumber
Look at the file it explane everry thing i whant
Attached Files
File Type: xlsx Kalendernmbs.xlsx (212.6 KB, 13 views)
Reply With Quote
  #2  
Old 11-04-2016, 01:08 PM
macropod's Avatar
macropod macropod is offline Calendar for holidays Windows 7 64bit Calendar for holidays Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,856
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Recreating your calendar with VBA would require a lot of work, especially for implementing your spinner buttons. It is not the kind of thing you could expect any forum to do for free - and this one doesn't offer commercial services. A VBA version might also run slower than what you now have and would also be much harder (even impossible) for anyone who is not an experienced VBA coder to maintain.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 11-04-2016, 01:23 PM
glda19 glda19 is offline Calendar for holidays Windows XP Calendar for holidays Office 2010 32bit
Novice
Calendar for holidays
 
Join Date: Apr 2011
Posts: 5
glda19 is on a distinguished road
Default

why should vba slower than a worksheet
Reply With Quote
  #4  
Old 11-04-2016, 01:28 PM
macropod's Avatar
macropod macropod is offline Calendar for holidays Windows 7 64bit Calendar for holidays Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,856
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Because that's just how things often are when you use VBA for jobs that can be done better with formulae. In any event, your current worksheet updates quite quickly, so that shouldn't be an issue.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #5  
Old 11-04-2016, 01:31 PM
glda19 glda19 is offline Calendar for holidays Windows XP Calendar for holidays Office 2010 32bit
Novice
Calendar for holidays
 
Join Date: Apr 2011
Posts: 5
glda19 is on a distinguished road
Default

can you help me to set automaticly the red lines
the function mod(b$3,4)=0 is no good. Because when the red line is between week 51 and 52 then 52 of the past year is the first colum of the block of 4 of the new year
Reply With Quote
  #6  
Old 11-04-2016, 02:26 PM
macropod's Avatar
macropod macropod is offline Calendar for holidays Windows 7 64bit Calendar for holidays Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,856
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

I can't help you with that - anytime I try to do anything using the year spinner on your workbook (which I can't read), all the calculated cells show #VALUE!, as a result of which I can't see what happens when the year changes.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
URGENT PLEASE: Project Calendar company holidays BarryB Project 2 09-17-2016 09:35 AM
Legal Holidays WildBill Outlook 0 08-06-2013 06:49 AM
Setting Emails to be send in calendar holidays to group of people Afshin r Outlook 0 11-13-2012 05:19 PM
Calendar for holidays New calendar in Outlook, no holidays Dirtnapepr Outlook 2 09-15-2010 06:07 AM
outlook 2007 holidays won't load to calendar rec Outlook 0 07-08-2010 12:52 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:21 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2022, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2022 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft