dabluebery
Board Regular
- Joined
- Sep 22, 2003
- Messages
- 83
Hey,
I'm in a VBA class, and I have a simple HW assignment that I don't quite understand. Here's the question;
Write a sub that asks for a product index from 1 to 100. Embed this within a Do loop so that the user keeps being asked until he enters an integer from 1 to 100. (use a For loop for checking)
I don't understand how I would use a for loop to check if the number is an integer. I understand the first part of the question, and already have a do loop checking if the value entered is numeric. If not, it prompts an input box until you do. Any insight is appreciated.
Rob
I'm in a VBA class, and I have a simple HW assignment that I don't quite understand. Here's the question;
Write a sub that asks for a product index from 1 to 100. Embed this within a Do loop so that the user keeps being asked until he enters an integer from 1 to 100. (use a For loop for checking)
I don't understand how I would use a for loop to check if the number is an integer. I understand the first part of the question, and already have a do loop checking if the value entered is numeric. If not, it prompts an input box until you do. Any insight is appreciated.
Rob