This is my macro but there is a syntax error somewhere in the code. This is what I have
Do
Range("purchase").Value = InputBox("Enter the purchase value of your bonds between the values of 0 and 1,000,000"
Loop Until Range("purchase").Value <= 1000000 And Range("purchase").Value >= 0
I'm trying to write a macro that has purchase price greater than 0 and less than or equal to 1,000,000.
module1. purchase is my attempt at a macro, go to Visual Basic.
Any help is appreciated.
Bookmarks