How to update a cell by one only!
How to update a cell by one only!
(OP)
I would like to allow end users to update some information but only to update the information by adding one at a time.
Example
On Monday the output was
A B C D E F
1 t1 9
2 t2 7
3
4 ttl 16
5
On Tuesday a User opens the file but it needs to add one to "1B". I would like for the user to increase 9 to ten.
A B C D E F
1 t1 10
2 t2 7
3
4 ttl 17
5
I would to prevent the user from deleting the entry or changing it to something else. What I was thinking is to force the users to add it by one by clicking on a button or something similar to that.
Can you please provide any kind of comments or suggestions regarding this subject will be appreciate.
Thank you in advance for your help!
Example
On Monday the output was
A B C D E F
1 t1 9
2 t2 7
3
4 ttl 16
5
On Tuesday a User opens the file but it needs to add one to "1B". I would like for the user to increase 9 to ten.
A B C D E F
1 t1 10
2 t2 7
3
4 ttl 17
5
I would to prevent the user from deleting the entry or changing it to something else. What I was thinking is to force the users to add it by one by clicking on a button or something similar to that.
Can you please provide any kind of comments or suggestions regarding this subject will be appreciate.
Thank you in advance for your help!





RE: How to update a cell by one only!
The easiest way to add a button is to activate the drawing tool bar then draw a text box. For the text, enter the label you want for your button. Now select the text box, right mouse click, and select Assign Macro... Pick the name of the macro you just recorded. Now when you hover over the text box the cursor will change and you can just click to run the macro.
Good luck
RE: How to update a cell by one only!
CODE
You should also seriously look at my last post in Thread770-109611
Good Luck
johnwm
________________________________________________________
To get the best from these forums read FAQ731-376 before posting
UK steam enthusiasts: www.essexsteam.co.uk
RE: How to update a cell by one only!