Hi Guys,
I need a code that if i make an workbook open that in a cell a text is displayed after a time i give in. I need to display Morning, Afternoon, Night.
So i need to change the text at 05:15 - 13:15 - and 21:15. I want it only to change if i open the workbook not if the workbook is active. So when i open the workbook say at 13:16 it is displaying "afternoon", Hope you understand my question. Feel free to ask.
Regards,
Black7
Last edited by black7; 08-21-2013 at 05:29 PM.
Put this macro in a standard code mdule (e.g.; Module1).
Change the Sheet name and Cell address to where you want the text displayed.
Please Login or Register to view this content.
Last edited by AlphaFrog; 08-21-2013 at 07:40 PM.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
Thank you so far, i want it to work on all sheets and the same cel. What must i change to get it to work ?
Black7
Please Login or Register to view this content.
Last edited by AlphaFrog; 08-21-2013 at 10:48 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks