PDA

View Full Version : Solved: How can i?? Press a button and it will make a calculation of +30days!



flashdazza
06-15-2008, 03:35 PM
With the system i have just made customer can select a game by pressing a button and the game will be place in a textbox called "txtRentalGame1" BUT i want to show the date it is due back so i have a textbox called "txtReturn1"

Is it possible so that when i press the button a calculation can be made similar to =(now) +30???

What would the code for this be??

Many Thanks

mikerickson
06-15-2008, 03:37 PM
myValue = Now() + 30Where do you want myValue stored? Which cell should it be stored in?

flashdazza
06-15-2008, 03:40 PM
It needs to be stored in a range called "customerZone" in cell "rowpointer, 10" but it should update everytime i open excel. Only when the game is taken out. So the final date always stays there until i clear it with a button called "btnClear"

mikerickson
06-15-2008, 03:52 PM
In the routine that puts the title in txtRentalGame1, add the line
Range("customerZone").Cells(rowpointer,10).Value = Now() + 30

flashdazza
06-15-2008, 04:35 PM
Thanks its all sorted now :) Cheers