FOR NEXT LOOP QUESTION

[dabluebery]

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

 

[NateO]

I thought you were being sarcastic.

I was still talking about Excel and VBA.

I don't understand any of this:

The Microsoft statement ("The disadvantage is that variant variables require at least 16 bytes of memory, which can be significant in large procedures or complex modules.") is not relevant in that the subject procedure is neither large nor complex.
(Also, assertions by Microsoft are not necessarily always reliable.)

How is this not relevant to Excel and VBA? The statement isn't large or complex, nor is that what they are saying, it's refering to large and complex procedures. It does not mean that such practices do not apply to small procedures. Microsoft may not always be 100% accurate in their support, but, they did create Excel, making them somewhat credible in my estimation.
Nor do I understand:

Also, can we mind the tone and nature of our discussions in this forum somewhat? Go argue in the lounge.

This forum is to discuss VBA and Excel, I'll continue to argue/debate/discuss (whatever) Excel & VBA here, thank you.

Irrespective of why you mentioned of dates, in actuality, I don't care, I vote to trap it all and use a variant, hence my revision. And I really don't see anything from my posts to this thread coming close to the tone you've demonstrated in this thread.

 

[Legacy 21301]

I thought you were being sarcastic.

Who me?

I don't understand any of this

Don't get disheartened - you will probably get there eventually.

How is this not relevant to Excel and VBA?

Did someone say it wasn't?

The statement isn't large or complex, nor is that what they are saying, it's refering to large and complex procedures

Did someone say otherwise?

it's refering to large and complex procedures

Which is what the procedure in this thread is not - so the potential saving in memory is 6 bytes, which I don't think is worth all this crap that is being posted.

Nor do I understand:
Also, can we mind the tone and nature of our discussions in this forum somewhat? Go argue in the lounge.

Merely paraphrasing your previous snotty remark. I do not believe you have exclusive entitlement to telling posters what and where to post.

Irrespective of why you mentioned of dates, in actuality, I don't care

Don't care about what?

I vote to trap it all and use a variant, hence my revision.

Extreme overkill in my opinion.

And I really don't see anything from my posts to this thread coming close to the tone you've demonstrated in this thread.

Again, don't be disheartened. With a little more experience and effort I'm sure you will eventually be able to get closer.