Need Help With Loop Until in VBA

Hey guys,

I've been starting to use VBA recently so its still pretty new to me
Although, i do know you can use it to add to a number in specific integers until a value is reached, I'm not completely sure how to write this.

for example

A1=1 and B1=5

If A1 is < B1 then A1 + .5 until A1 >= B1

Anyone have any suggestions,
whatever help provided would be much appreciated.

Please Login or Register  to view this content.

Maybe:

Please Login or Register  to view this content.

Thanks for your responses!

Does there happen to be a way to do this automatically?
I've entered the codes you provided and it doesn't seem to do anything with the numbers in the cells.

If there is a way to do this automatically, is there also a way to apply this to a command button?

Maybe:

Please Login or Register  to view this content.

Not really getting your point? Why not just A1 = B1. Or maybe I'm misunderstanding you.

Thanks for your help but i was able to figure it out with some external sources.

The VBA code came out looking like this:


Sub LoopUntil()
Do While Range("a1") < Range("b1")
Range("a1") = Range("a1") + 0.5
Loop


End Sub


Private Sub CommandButton1_Click()
LoopUntil
End Sub