PDA

View Full Version : Automatically increment single cell from 15 to 150



johan4b
09-14-2016, 05:27 AM
Hi Guys

i hope you can help me with a problem i searched it but cant find anything.

I have a excel sheet that does an calculation when a certain number is typed in cell B2 the value in B3 changes with it.

What i want is that vba does a increment from 15 to 150 and stops when the value in B3 changes.

I hope im cleare and thank you

17079

snb
09-14-2016, 06:27 AM
We don't like crossposting:

http://www.helpmij.nl/forum/showthread.php/900211-optellen-van-15-tot-150-in-enkele-cell

Paul_Hossler
09-14-2016, 07:20 AM
... without at least mentioning it

This way we know if the question has been answered, and we do not need to look at it here

SamT
09-14-2016, 07:59 AM
Double Posting: http://www.vbaexpress.com/forum/showthread.php?57148-stop-incrementing

Johan,

You are new here so we Forgive you this time.

Please read http://www.vbaexpress.com/forum/faq.php, especially, What is multiposting? (http://www.vbaexpress.com/forum/faq.php?faq=new_faq_item#faq_new_faq_item3)

Kindly allow one of your two threads to die a natural death, or tell me and I can delete one of them.




Some Hints about this Forum:

You must post a few time before you can post a link. You can still post a web address if you leave the "http://" off the address,

You can upload a Workbook by using the "Manage Attachments" button below the Advanced Editor.

The Editor Menu, #, will insert CODE Tags into your post that you can place your code in. Select the code and click the # or click the # then paste your code between the CODE Tags.