Hey my friends,
I'd like to get two VBA codes to increase and decrease the value in cell A1 one by one.
If A1 value is 23, when I run "increase VBA", A1 should be 24. or if I click to run "decrease VBA" , it should be 22. and so on. Also it should continue to run. I mean, If I click to run "decrease VBA" three times in a row, cell value should be 20.
Can you help me with it please? Thank you.
Hi aaaaa34,
Assuming the buttons are on the same sheet as the A1 value (otherwise the sheet needs to be referenced in the code):
I've put in the check for A1 being numeric to avoid any errors.
Please Login or Register to view this content.
Please help by:
Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know
There are 10 kinds of people in this world... those who understand binary, and those who don't.
Please Login or Register to view this content.
Thank you so much for your fast response bro.Originally Posted by nigelog
I want to ask you that f i want to run this code for E5 cell for example, how I should modify these "Cells(1, 1).Value = Cells(1, 1).Value + 1"
Well you could use Range instead of Cells if that makes it easier (see my post) or just edit Cells(1,1) to Cells(5,5). The syntax for "Cells" is (row number, column number)
As Arkadi said - change to eitherorPlease Login or Register to view this content.Please Login or Register to view this content.
Oke nigel de jong. Now i got it.
arkadiusz milik, thank you so much too for post #2. It works great.
both of your names reminded me these players : )
I want to use your codes with some modifications.
Thank you.
Last edited by aaaaa34; 06-14-2019 at 10:10 AM. Reason: I will submit my request in new thread.
That is a different question and should be the subject of a new thread. Other participants may get involved to help find your answer if you do. If this first question has been answered then please mark thread as solved and start with a new thread with an accurate description of what you are hoping to achieve. Rgds
oke nigel.
If Arkadi doesn't want to reply here too, I will open a new thread.
Now I mark this thread solved so fast. Thank you.
aaaaa34, nigel was right that it is a different request, and since he already asked for a new thread to be created, I will respect that. Happy to help if you start a new one though
p.s. I guess you are a big soccer fan?
off course I love soccer a lot and follow all european soccer leagues.
Arkadiusz Milik, plays for Napoli, not big star like Lewandowski, but very talented and they score a lot together for Poland : ))))
Cool
Once you start a new thread for the new question about max/min restrictions, I can give you some code for that.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks