Hello, first of all, I'm sorry 'cuz of my harsh english language, but I hope you'll get the point..
So, I'm creating some sort of excel diary for daily routines at work. Let's say I come to work at 7am, I open this excel diary, write down my name and time I arrived, and at the end of the day, I write down the time I left.
I'm using Calendar control for picking a day/month/year (question; is it possible to link calendar control to worksheet, that when I pick a day it opens a new sheet, where I'm allowed to write down some comments and notes during day??)
I have commandbutton "SAVE" that is linked to cell where I wrote my name in the beginning (Blobbbb) , and when I tab "SAVE", file will be saved as a name Blobbbb.
So is it possible to use Calendar control for picking up a date, that opens a new sheet, and where to I'm able to write down some information, comments and notes about the day, working time etc. any other stuff that happens during day. And at the end of the day, possible to Save all this, so that when I do these same things day after, I'm able to search information what I did yesterday. Let's say I come to work 11.11.2011, blbaablaablaa, SAVE, then 11.10.2014, I'm able to search this date 11.11.2011 ?????? Anyone understood what the h_ll did I just said?? Please help, any help would be very approciated. Thanks in advance!!
So, I'm creating some sort of excel diary for daily routines at work. Let's say I come to work at 7am, I open this excel diary, write down my name and time I arrived, and at the end of the day, I write down the time I left.
I'm using Calendar control for picking a day/month/year (question; is it possible to link calendar control to worksheet, that when I pick a day it opens a new sheet, where I'm allowed to write down some comments and notes during day??)
I have commandbutton "SAVE" that is linked to cell where I wrote my name in the beginning (Blobbbb) , and when I tab "SAVE", file will be saved as a name Blobbbb.
So is it possible to use Calendar control for picking up a date, that opens a new sheet, and where to I'm able to write down some information, comments and notes about the day, working time etc. any other stuff that happens during day. And at the end of the day, possible to Save all this, so that when I do these same things day after, I'm able to search information what I did yesterday. Let's say I come to work 11.11.2011, blbaablaablaa, SAVE, then 11.10.2014, I'm able to search this date 11.11.2011 ?????? Anyone understood what the h_ll did I just said?? Please help, any help would be very approciated. Thanks in advance!!
