Just recently I was referred to this Calendar with comments through a post by Ken Puls. When I open it up and have a look at the form "DatePick" it is not like other forms that I've seen before, as it has controls overlapping others.
Would someone please take the time to explain the layout for me please?
I had hoped that I might be able to use something like this as a personal Calendar. I just want to pop up the calendar to show me what I should be doing in the upcoming days.
Ted
Remember To Do the Following....
Use [Code].... [/Code] tags when posting code to the thread.
Mark your thread as Solved if satisfied by using the Thread Tools options.
If posting the same issue to another forum please show the link
Yep I know.... too eager and forgot to attach the file. Maybe its because I'm on the down hill section of my life.
Remember To Do the Following....
Use [Code].... [/Code] tags when posting code to the thread.
Mark your thread as Solved if satisfied by using the Thread Tools options.
If posting the same issue to another forum please show the link
You just add the evnts and the comments to the worksheet, so it seems the calendar is just a display. Don't know why you can't add the events to the form directly. Change some of the dates to see it in action
Yes I've done that Bob. I'm more interested in why when I open the datepick form and view the object in the VBE, it has a form with control objects in a layout which is not like the actual form you see when in Excel. I was wondering if someone can tell me why the form looks like it does.
Ted
Remember To Do the Following....
Use [Code].... [/Code] tags when posting code to the thread.
Mark your thread as Solved if satisfied by using the Thread Tools options.
If posting the same issue to another forum please show the link
For some reason, maybe just practice, Ken has used code to place and size the controls. Where controls are dynamic in size, then this allows other controls to be placed in relative positions. I've not checked, but you can also ensure that controls are relative to monitor display size.
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
For the record, it wasn't Ken who built it. It was BlueCactus.
Malcolm is correct. Rather than go to the pain of trying to line everything up, he just repositioned things on the fly by code.
Ken Puls, CMA - Microsoft MVP (Excel)
I hate it when my computer does what I tell it to, and not what I want it to.
Learn how to use our KB tags! -||- Ken's Excel Website -||- Ken's Excel Forums -||- My Blog -||- Excel Training Calendar
This is a shameless plug for my new book "RibbonX - Customizing the Office 2007 Ribbon". Find out more about it here!
Help keep VBAX clean! Use the 'Thread Tools' menu to mark your own threads solved!
Sorry, didn't mean to infer that you built it Ken, just that my attention was drawn to this set of code by your post.
So I should have no problem adding a button to add new data, by bringing up a new form. Data would be sets of two sporting teams and their game location on a date.
Remember To Do the Following....
Use [Code].... [/Code] tags when posting code to the thread.
Mark your thread as Solved if satisfied by using the Thread Tools options.
If posting the same issue to another forum please show the link
You can add a new button, but you will have to play about with its position as you can see in design mode where the existing buttons end up.
Posting Permissions
Reply With Quote
