Printable View
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
Yep I know.... too eager and forgot to attach the file. Maybe its because I'm on the down hill section of my life.
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
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.
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.
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.
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.