View Full Version : Solved: Enter date in a cell
av8tordude
03-04-2010, 07:11 PM
I have a date currently entered into B5. I have 2 buttons (previous & next). I would like to display in B5 the previous day from the date currently in B5 each time I click the previous button. I also would like to do the same with the next button.
Can someone help. Thank you
Hi,
To set the macro select the shape, do right click and assign the macro to the shape. Press Alt-F11 to see the code in the attachment.
Regards,
Vladimir
av8tordude
03-04-2010, 08:48 PM
Thank you for your help, ZVI :friends:
Thank you for your help, ZVI :friends:
Glad it helped!
Another approach without macro can be in using of SpinButton control from Visual Basic control panel. Its LinkedCell property is set to B5 cell - see the enclosed Book2.xlsx
Cheers,
Vladimir
av8tordude
03-04-2010, 09:41 PM
Thanks for tip!! I'll give both a try :beerchug:
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.