Hello,
I am new to VBA and need some help.
Basically i have this database full of food names, prices, and catergories (entree, side, drink)
I have the user enter the amount of money they have.
From here, the user presses OK and a meal (1 entree, 1 side, 1 drink) is suppose to be generated.

currently, i have only functions, and since i discovered i cannot do a loop with functions (gives circular reference error), I figure VBA is what to do.
SO, i have a random number generator that picks a number 1-end of list. in my case it is 1-65. From there is does a VLOOKUP and sees if the category is entree. IF true, ir displays the food name and price. NOW i need help. Sometimes it generates a random number, say 4. 4 is Water in my database so it displays nothing. How can i make a loop out of this?


THANKS!