Add button to start count of how many day since last klick. Add button to count % of total

Hi,

Give this a go: SinceLastClick.xlsm

Hope this is what you were after

**** man, thanks alot! Wow!

I tried to change some stuff, bud dident make it. And the buttons was impossible to move?

I would like to make the click buttom as big as a cell. And to fit the size. Is that possible?

Exampel.xlsx

Edit: Looks like I switched the "e" and "l" in Example.

It sure is, just enter Design Mode and then you will be able to move and resize the buttons.

I haven't used Excel 2003 before, so you may need to look in the help files for how to enter Design Mode (or hopefully someone will see this post and let you know through this forum). All I know is it has something to do with the Control Toolbox (if this means anything to you).

Please don't forget to mark this thread as solved once you are satisfied with the solution, and click the star on the bottom-left of my post to say thanks

Hello again,

I have managed to change things around alittle - thanks.

Is it possible to change the "Update button" lable to the % of total updates?

And another thing. I want all of this to be in one row. This because I want to have alot of rows, like 200. And the button and % should be uniqe for each row. To my question: Can you copy the button and % functions to each row? Withouth loosing the uniqe % for each row?

Yes, you can have the button update to the % of total updates. I have now updated the example that I sent you last time, which means you will have to move your buttons around again, or alternatively copy and past the code into your own working spreadsheet.

Yes the buttons can be copied, but the code would have to be altered considerably to accommodate 200 rows, as I have only written it to accommodate 5 rows.

Hello again,

Getting closer! Thank you for the help so far, added some reputation for the awesome help.

I have attatched the file as I have changed it. Some things is getting weird. When I exited design mode and tried the button the data I had placed in the cells where the % used to be became the title of the button changed and I couldent go back to change it and I dont understand how the coding is done. Could you please change back? And maybe change so that I can have those cells filled up without risking the title to be changed? It is a total of 168 rows and the column is reaching "AL".

And I would also like to add more history, up to update 20. Is that possible to change? And is it possible to save the total numbers of updates under "Total updates"?

And the last thing, how to multiple the rows? I want it uniqe data for up to the 168th row.

Thanks again, really appreciate your help..!

SinceLastClick (1).xlsm