[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Switch Calendar option

Posted on 2011-04-24
8
Medium Priority
?
185 Views
Last Modified: 2012-05-11
Hi Experts,

I would like to request Experts help to set a control for Option Button 1 and 2 to allow switch between Calendar A or B from “Date” sheet. Based on this Option Button selection,  data at cell B2 to C54 at “Chart” sheet will switch either Calendar A or B data. Hope Experts will me to create this feature.



ChartDate.xls
0
Comment
Question by:Cartillo
  • 4
  • 4
8 Comments
 
LVL 16

Expert Comment

by:Peter Kwan
ID: 35458293
Please see if the attached works for you.
ChartDate.xls
0
 

Author Comment

by:Cartillo
ID: 35458633
Hi pkwan,

Thanks for solution, any possibilities to speed up the switching, currently it takes too long to respond.
0
 
LVL 16

Expert Comment

by:Peter Kwan
ID: 35458669
Hi,

Please try the attached to check whether the performance is faster. Thanks.
ChartDate.xls
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 

Author Comment

by:Cartillo
ID: 35458856
Hi,

Try to adopt the solution in my actual workbook at Chart 2 but it show an error as “The specific dimension not valid for the current  chart  type”. How to fix this? Attached the workbook for your perusal. Hope you will consider this request.

ChartData-update.xls
0
 
LVL 16

Expert Comment

by:Peter Kwan
ID: 35458880
Hi,

You may please try to replace
      Sheet2.Paste Range("B2") 

Open in new window

with
       Sheet2.Paste Sheet2.Range("B2") 

Open in new window


Thanks.
0
 

Author Comment

by:Cartillo
ID: 35458963
Hi,
Tested, its not copying the date. Please assist.
0
 
LVL 16

Accepted Solution

by:
Peter Kwan earned 2000 total points
ID: 35459144
Hi,

I have tried the attached and find it working. Please retry.
ChartData-update.xls
0
 

Author Closing Comment

by:Cartillo
ID: 35460668
Hi pkwan,

Thanks a lot for the help
0

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

831 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question