Hi All
I'm completely new to VBA and just need guidance on what I'm doing wrong....
I have a very simple spreadsheet called general to which I want to add a calendar control designed completely using vba coding to it.
However when I simply pull the object, form and module across to my spreadsheet i encounter all kinds of issues/compile errors/missing library/components etc....and I'm not sure how to get the code across properly...
I have also attached a second version where I seem to have pulled the code across, however the calendar doesn't work!
What I would like it to do is activate the calendar control when I click in cell A2:A5000, choose the date and then have it insert it into the cell I selected in the above range.
The calendar control has been designed by someone else and looking through various posts in other forums it seems to work fine....so it must be me and my lack of skills....
Thanks for any help...
I'm completely new to VBA and just need guidance on what I'm doing wrong....
I have a very simple spreadsheet called general to which I want to add a calendar control designed completely using vba coding to it.
However when I simply pull the object, form and module across to my spreadsheet i encounter all kinds of issues/compile errors/missing library/components etc....and I'm not sure how to get the code across properly...
I have also attached a second version where I seem to have pulled the code across, however the calendar doesn't work!
What I would like it to do is activate the calendar control when I click in cell A2:A5000, choose the date and then have it insert it into the cell I selected in the above range.
The calendar control has been designed by someone else and looking through various posts in other forums it seems to work fine....so it must be me and my lack of skills....
Thanks for any help...