• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. S

    Fully Customizable VBA Date Picker

    Hi macdonaldj. As others have mentioned, the date picker isn't set up to be embedded on another user form, but it can be accomplished with a bit of tweaking. The entire date picker is contained within a frame control, so you should be able to place that frame within a larger user form to achieve...
  2. S

    Fully Customizable VBA Date Picker

    Thanks, everyone! Glad you like it. One thing I am curious about is if the calendar holds up okay with different date formatting tendencies internationally. I've never dealt with distributing a spreadsheet outside the United States, so that was something I didn't really know how to account for...
  3. S

    How to sort a pivot, but not by the first column

    I believe you can do multiple sorts, and I don't think all fields necessarily have to be in the values column. It really just depends on your pivot table setup. So I couldn't really give you a definitive answer on that one. As for the values field not setting the custom name, correctly, I'm not...
  4. S

    How to sort a pivot, but not by the first column

    Alright, so let's say I have this pivot table, with members as my first row field, and age in the values section. In the Pivot Fields on the right hand side of the screen, click on the arrow next to the field that you have in the rows section (you want to click on the arrow in the list of...
  5. S

    How to sort a pivot, but not by the first column

    This is a little counter-intuitive, but I believe what you need to do is sort the first column, but by the values in another column. So in your Pivot Field List, if you click the little options arrow next to whichever field you have in the first column, you should see 'Sort A to Z', 'Sort Z to...
  6. S

    Fully Customizable VBA Date Picker

    I recently created a customizable, VBA-based date picker, and thought it might be of use to someone else. I know there are already a lot of custom date pickers out there to overcome the difficulties of using Microsoft's MonthView control. But I wanted one that could be customized to match the...
Back
Top