PDA

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

ZVI
03-04-2010, 08:24 PM
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:

ZVI
03-04-2010, 08:55 PM
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: