FOR NEXT LOOP QUESTION :: MrExcel Message Board


 FAQFAQ
   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   FavoritesFavorites   StatisticsStatistics 
 RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 
Online StoreOnline Store

MrExcel Message Board Forum Index -> Excel Questions

FOR NEXT LOOP QUESTION
Post new topic   Reply to topic
Last Thread | Next Thread  >   Printable version
  Author    Thread

dabluebery
Board Regular


Joined: 22 Sep 2003
Posts: 46
Location: Long Island, NY
Flag: Usa

Status: Offline

 Reply with quote  

FOR NEXT LOOP QUESTION

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

Post Fri Nov 14, 2003 9:38 pm 
 View user's profile Send private message Send e-mail AIM Address

Ponsy Nob.
Board Master


Joined: 26 Sep 2003
Posts: 472

Flag: Israel

Status: Offline

 Reply with quote  

Re: FOR NEXT LOOP QUESTION

Post what code you have so far.

Post Sat Nov 15, 2003 12:22 am 
 View user's profile Send private message

SIXTH SENSE
Board Master


Joined: 29 Oct 2003
Posts: 916

Flag: Blank

Status: Offline

 Reply with quote  

try this.
for i=1 to 100
if inputX=i then
msgbox "input is valid!!! "
exit for
elseif inputX<>i and i=100 then
msgbox "input is invalid!!!!! "
end if
next i
_________________
There is always a better way!!

Post Sat Nov 15, 2003 2:20 am 
 View user's profile Send private message

Nimrod
MrExcel MVP


Joined: 30 Apr 2002
Posts: 2552
Location: Vancouver BC , Canada

Status: Offline

 Reply with quote  

Re: FOR NEXT LOOP QUESTION

First of all its a good idea to use "Application.inputbox" versus "inputBox" as "Application.inputbox" allows you to specify what kind of data is allowed to be entered. IN the example below you can see the parmeter " Type:=1" this mean that only numbers will be allowed. If you type in letters or special charcters the following code will give you an error message and send you back into the loop.

The Response = Int (Response ) in the loop makes sure the number is an integer.

So the following code test to make sure the Entry is a number and an integer. If it isn't then you don't get to exit the Do...loop ! icon_wink.gif


Public Sub AskForNum()
Do
Response = Application.InputBox("Please Enter Integer Between 1 and 100", "Enter Number", Type:=1)
Loop Until Reponse > 0 And Response < 101 And Reponse = Int(Response)
End Sub
_________________
NOTE: (Testing performed on Win2K utilizing Office 2000. Solutions may need tweaking for other versions.)
Adieu,Nimrod

Post Sat Nov 15, 2003 4:48 am 
 View user's profile Send private message AIM Address

Nimrod
MrExcel MVP


Joined: 30 Apr 2002
Posts: 2552
Location: Vancouver BC , Canada

Status: Offline

 Reply with quote  

Re: FOR NEXT LOOP QUESTION

OOOOOOPSSSSS icon_biggrin.gif A TYPO CREPT INTO MY CODE ABOVE icon_redface.gif It's been corrected in the following code .. icon_rolleyes.gif

Public Sub AskForNum()
Do
Response = Application.InputBox("Please Enter Integer Between 1 and 100", "Enter Number", Type:=1)
Loop Until Response > 0 And Response < 101 And Response = Int(Response)
End Sub
_________________
NOTE: (Testing performed on Win2K utilizing Office 2000. Solutions may need tweaking for other versions.)
Adieu,Nimrod

Post Sat Nov 15, 2003 7:23 am 
 View user's profile Send private message AIM Address

Ponsy Nob.
Board Master


Joined: 26 Sep 2003
Posts: 472

Flag: Israel

Status: Offline

 Reply with quote  

Re: FOR NEXT LOOP QUESTION

quote:
Originally posted by Nimrod:
OOOOOOPSSSSS icon_biggrin.gif A TYPO CREPT INTO MY CODE ABOVE icon_redface.gif It's been corrected in the following code .. icon_rolleyes.gif

Public Sub AskForNum()
Do
Response = Application.InputBox("Please Enter Integer Between 1 and 100", "Enter Number", Type:=1)
Loop Until Response > 0 And Response < 101 And Response = Int(Response)
End Sub


But what about dates from 1 Jan 1900 to 9 April 1900 ?

Post Sat Nov 15, 2003 1:06 pm 
 View user's profile Send private message

Nimrod
MrExcel MVP


Joined: 30 Apr 2002
Posts: 2552
Location: Vancouver BC , Canada

Status: Offline

 Reply with quote  

Re: FOR NEXT LOOP QUESTION

Heres an Upgraded version of my last posting ... This version has the following features:
1. uses type:=1 to check that entry is number
2. will exit loop if the cancel button on input box is selected eg. if Response = False
3. Changes the input message if you make wrong entry
4. Checks response is an integer using "Response = Int(Response) "
5. additional Error message will popup with if entry is left blank or has invalid entry .



Public Sub AskForNumV2()
Do
Response = Application.InputBox(agn & "Please Enter Integer Between 1 and 100", "Enter Number", Type:=1)
If Response = False Then Exit Sub
agn = "Sorry the entry... " & Response & " ..is invalid" & vbCrLf
Loop Until Response > 0 And Response < 101 And Response = Int(Response)
End Sub



Note: Mr. Nob posted and asked a question about dates.... I have no idea what your question means since we're not dealing with dates here ???

icon_beerchug.gif
_________________
NOTE: (Testing performed on Win2K utilizing Office 2000. Solutions may need tweaking for other versions.)
Adieu,Nimrod

Post Sat Nov 15, 2003 5:31 pm 
 View user's profile Send private message AIM Address

pennysaver
Board Master


Joined: 15 May 2003
Posts: 2202
Location: San Diego, California
Flag: Usa

Status: Offline

 Reply with quote  

Re: FOR NEXT LOOP QUESTION

I think Mr. Nob meant what happens if someone enters 1/1/1900 and the system interprets it as "1", same with 4/9/1900 being "100".

Post Sat Nov 15, 2003 7:53 pm 
 View user's profile Send private message Visit poster's website MSN Messenger

Ponsy Nob.
Board Master


Joined: 26 Sep 2003
Posts: 472

Flag: Israel

Status: Offline

 Reply with quote  

Re: FOR NEXT LOOP QUESTION

Since Mr. Nimrod has not re-appeared to address my query (clarified by Mr. pennysaver), here is a suggested amendment to Mr. Nimrod's code.

The amended code will accept input of the numbers 1 to 100 only, and prevents (will not accept) dates.

code:
Public Sub AskForNumV2()
Do
response = Application.InputBox(agn & "Please Enter Integer Between 1 and 100", "Enter Number")
If response = False Then Exit Sub
agn = "Sorry the entry... " & response & " ..is invalid" & vbCrLf
Loop Until Val(response) > 0 And Val(response) < 101 And response = Int(Val(response)) And Not IsDate(response)
MsgBox "You successfully entered " & Val(response)
End Sub


Post Mon Nov 17, 2003 9:24 am 
 View user's profile Send private message

Nimrod
MrExcel MVP


Joined: 30 Apr 2002
Posts: 2552
Location: Vancouver BC , Canada

Status: Offline

 Reply with quote  

Re: FOR NEXT LOOP QUESTION

I'm on the road for the next few day's but have checked in. In response to Mr. Nobs concerns about entry of dates , I don't see how dates are a concern as the Type:= 1, prevents anything but numbers being entered into the input box. This "feature" of the input box has been explained in my previous postings ... OK ? icon_confused.gif
_________________
NOTE: (Testing performed on Win2K utilizing Office 2000. Solutions may need tweaking for other versions.)
Adieu,Nimrod

Post Tue Nov 18, 2003 8:15 pm 
 View user's profile Send private message AIM Address

santeria
Board Master
Board  Master


Joined: 07 Oct 2003
Posts: 1364
Location: Tallahassee
Flag: Usa

Status: Offline

 Reply with quote  

Re: FOR NEXT LOOP QUESTION

What can I say ... Enjoyable set of Posts icon_laugh.gif

icon_bow.gif
_________________
"Don't Ruin an Apology with an Excuse"...

Post Tue Nov 18, 2003 8:25 pm 
 View user's profile Send private message

Ponsy Nob.
Board Master


Joined: 26 Sep 2003
Posts: 472

Flag: Israel

Status: Offline

 Reply with quote  

Re: FOR NEXT LOOP QUESTION

quote:
Originally posted by Nimrod:
I'm on the road for the next few day's but have checked in. In response to Mr. Nobs concerns about entry of dates , I don't see how dates are a concern as the Type:= 1, prevents anything but numbers being entered into the input box. This "feature" of the input box has been explained in my previous postings ... OK ? icon_confused.gif


Not OK.

On my computer, Excel recognizes a date as a number and therefore your code accepts date inputs.

Have you actually tried it ?

Post Tue Nov 18, 2003 11:42 pm 
 View user's profile Send private message

Nimrod
MrExcel MVP


Joined: 30 Apr 2002
Posts: 2552
Location: Vancouver BC , Canada

Status: Offline

 Reply with quote  

Re: FOR NEXT LOOP QUESTION

Mr Nob:

I will be off "the road" on friday and will take a look at your concerns at that time. Currently I'm at a Comdex convention using the "Cyber Centers" computers that do not have Excel. Please indicate exactly what you typing in and I will certainly address your concerns before the end of the week.

Have a nice day icon_cool.gif
_________________
NOTE: (Testing performed on Win2K utilizing Office 2000. Solutions may need tweaking for other versions.)
Adieu,Nimrod

Post Wed Nov 19, 2003 9:57 pm 
 View user's profile Send private message AIM Address

Ponsy Nob.
Board Master


Joined: 26 Sep 2003
Posts: 472

Flag: Israel

Status: Offline

 Reply with quote  

Re: FOR NEXT LOOP QUESTION

quote:
Originally posted by Nimrod:
Mr Nob:

I will be off "the road" on friday and will take a look at your concerns at that time. Currently I'm at a Comdex convention using the "Cyber Centers" computers that do not have Excel. Please indicate exactly what you typing in and I will certainly address your concerns before the end of the week.

Have a nice day icon_cool.gif


No need to be be such a patronising shit.

The problem is not mine. I fully understand how Excel treats dates and was merely trying to help you to improve your knowledge of Excel.

Try testing your code properly and looking up the Help files so you can establish for yourself the shortcomings of your suggested macro.

Post Thu Nov 20, 2003 12:22 am 
 View user's profile Send private message

pennysaver
Board Master


Joined: 15 May 2003
Posts: 2202
Location: San Diego, California
Flag: Usa

Status: Offline

 Reply with quote  

Re: FOR NEXT LOOP QUESTION


quote:
No need to be be such a patronising shit.


Nor you...

Smitty

Post Thu Nov 20, 2003 3:55 am 
 View user's profile Send private message Visit poster's website MSN Messenger

Ponsy Nob.
Board Master


Joined: 26 Sep 2003
Posts: 472

Flag: Israel

Status: Offline

 Reply with quote  

Re: FOR NEXT LOOP QUESTION

quote:
Originally posted by pennysaver:

quote:
No need to be be such a patronising shit.


Nor you...

Smitty


Say it with me "Irony is my friend..."

Post Thu Nov 20, 2003 7:32 am 
 View user's profile Send private message

Nimrod
MrExcel MVP


Joined: 30 Apr 2002
Posts: 2552
Location: Vancouver BC , Canada

Status: Offline

 Reply with quote  

Re: FOR NEXT LOOP QUESTION

Hello Mr Nob
Hmmmm….. I didn’t realize I was a “patronising s**t”. icon_exclaim.gif As I explained in my earlier posts I was “on the road” and had no excel to test “a date” to see what you were talking about. I feel I was quite polite to you in my posts and am surprised by the feedback I have received from you.
Now that I am back home and can test dates I see that the Type:=1 does allow dates of certain formats to be seen as numbers. So thanks for pointing that out…. I just wish you could have done that with a little more … tack . icon_wink.gif
Anyway I’ve looked at your code and found the suggested modifications that test for dates to be a good idea. However I’m not understanding the need to slow the procedure down by calling the “val” function several times ? As the following code seems to work just fine.
I certainly appreciate your input on the code though I hope you can cut me a little slack with the “attitude”. Thx.
icon_bow.gif

Public Sub AskForNumV5()
Do
Response = Application.InputBox(agn & "Please Enter Integer Between 1 and 100", "Enter Number")
If Response = False Then Exit Sub
agn = "Sorry the entry... " & Response & " ..is invalid" & vbCrLf
Loop Until Response > 0 And Response < 101 And Not IsDate(Response)
MsgBox "You successfully entered " & Val(Response)
End Sub
_________________
NOTE: (Testing performed on Win2K utilizing Office 2000. Solutions may need tweaking for other versions.)
Adieu,Nimrod

Post Sat Nov 22, 2003 1:58 am 
 View user's profile Send private message AIM Address

Ponsy Nob.
Board Master


Joined: 26 Sep 2003
Posts: 472

Flag: Israel

Status: Offline

 Reply with quote  

Re: FOR NEXT LOOP QUESTION

quote:
Originally posted by Nimrod:

I’m not understanding the need to slow the procedure down by calling the “val” function several times ?



Hmmm .... picky as well as patronising.

It does appear that using Val is not necessary and that your line of code :
Loop Until Response > 0 And Response < 101 And Not IsDate(Response)
does the same as :
Loop Until Val(response) > 0 And Val(response) < 101 And response = Int(Val(response)) And Not IsDate(response).

However, using Timer I recorded no difference in the run time of each of alternative.

This means that if there is any difference in the run times and there is in fact a "slow down" of the procedure, it must be less than one hundreth of a second.

(Also, "several times" could be considered by some to be an unusual term to describe three times.)

Post Tue Dec 02, 2003 7:03 pm 
 View user's profile Send private message

Nimrod
MrExcel MVP


Joined: 30 Apr 2002
Posts: 2552
Location: Vancouver BC , Canada

Status: Offline

 Reply with quote  

Re: FOR NEXT LOOP QUESTION

Mr Nob:

I enjoy helping people and that's why I come here. I've tried to understand and help you out. In return I've find you rude . Since I don't enjoy my communication with you it only makes sense that I avoid it .

Your an intelligent person though I do hope you learn some better communicatin skills so that you can fulfil your full potential.

Good Luck ... an I'm not being sarcastic. icon_beerchug.gif
_________________
NOTE: (Testing performed on Win2K utilizing Office 2000. Solutions may need tweaking for other versions.)
Adieu,Nimrod

Post Tue Dec 02, 2003 7:59 pm 
 View user's profile Send private message AIM Address

Ponsy Nob.
Board Master


Joined: 26 Sep 2003
Posts: 472

Flag: Israel

Status: Offline

 Reply with quote  

Re: FOR NEXT LOOP QUESTION

quote:
Originally posted by Nimrod:
Mr Nob:

I enjoy helping people and that's why I come here. I've tried to understand and help you out. In return I've find you rude . Since I don't enjoy my communication with you it only makes sense that I avoid it .

Your an intelligent person though I do hope you learn some better communicatin skills so that you can fulfil your full potential.

Good Luck ... an I'm not being sarcastic. icon_beerchug.gif



"I've tried to understand and help you out .... I do hope you learn some better communicatin skills so that you can fulfil your full potential"

Absolutely wonderful!
Exactly the sort of patronising crap I was referring to.

Post Tue Dec 02, 2003 8:38 pm 
 View user's profile Send private message

NateO
MrExcel MVP


Joined: 18 Feb 2002
Posts: 4311
Location: Minneapolis, Mn, USA
Flag: Usa

Status: Offline

 Reply with quote  

Re: FOR NEXT LOOP QUESTION

AskForNumV2() allows a string entry of False

You can correct for this by using:

Sub AskForNumV3()
Dim response As Variant
Do: response = Application.InputBox(agn & _
    "Please Enter Integer Between 1 and 100", "Enter Number")
If response = False And Not TypeName(response) = "String" Then Exit Sub
agn = "Sorry the entry... " & response & " ..is invalid" & vbNewLine
Loop Until Val(response) > 0 And Val(response) < 101 And _
    response = Val(response) \ 1 And Not IsDate(response)
MsgBox "You successfully entered " & response
End Sub


Keep the Val() functions to guard your procedure against string entries.

Also, can we mind the tone and nature of our discussions in this forum somewhat? Go fight in the lounge. icon_smile.gif
_________________
Regards,
Nate Oliver

Post Tue Dec 02, 2003 9:07 pm 
 View user's profile Send private message

Ponsy Nob.
Board Master


Joined: 26 Sep 2003
Posts: 472

Flag: Israel

Status: Offline

 Reply with quote  

Re: FOR NEXT LOOP QUESTION

quote:
Originally posted by NateO:
AskForNumV2() allows a string entry of False

You can correct for this by using:

Sub AskForNumV3()
Dim response As Variant
Do: response = Application.InputBox(agn & _
    "Please Enter Integer Between 1 and 100", "Enter Number")
If response = False And Not TypeName(response) = "String" Then Exit Sub
agn = "Sorry the entry... " & response & " ..is invalid" & vbNewLine
Loop Until Val(response) > 0 And Val(response) < 101 And _
    response = Val(response) \ 1 And Not IsDate(response)
MsgBox "You successfully entered " & response
End Sub


Keep the Val() functions to guard your procedure against string entries.

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


That's the same as I posted earlier in this thread.

Post Tue Dec 02, 2003 9:22 pm 
 View user's profile Send private message

NateO
MrExcel MVP


Joined: 18 Feb 2002
Posts: 4311
Location: Minneapolis, Mn, USA
Flag: Usa

Status: Offline

 Reply with quote  

Re: FOR NEXT LOOP QUESTION

Hello,

quote:
Originally posted by Ponsy Nob:
That's the same as I posted earlier in this thread.

It's not the exact same as:

http://www.mrexcel.com/board2/viewtopic.php?t=69222&start=8

Run V2, type False into the input box. Do the same with V3 that I just posted. See the If statement for the tweak.

Otherwise, did you post another procedure that I'm missing?
_________________
Regards,
Nate Oliver

Post Tue Dec 02, 2003 9:30 pm 
 View user's profile Send private message

Ponsy Nob.
Board Master


Joined: 26 Sep 2003
Posts: 472

Flag: Israel

Status: Offline

 Reply with quote  

Re: FOR NEXT LOOP QUESTION

quote:
Originally posted by NateO:
Hello,

quote:
Originally posted by Ponsy Nob:
That's the same as I posted earlier in this thread.

It's not the exact same as:

http://www.mrexcel.com/board2/viewtopic.php?t=69222&start=8

Run V2, type False into the input box. Do the same with V3 that I just posted. See the If statement for the tweak.

Otherwise, did you post another procedure that I'm missing?


OK (but can't think why anyone would consider it necessary).

Post Tue Dec 02, 2003 9:43 pm 
 View user's profile Send private message

NateO
MrExcel MVP


Joined: 18 Feb 2002
Posts: 4311
Location: Minneapolis, Mn, USA
Flag: Usa

Status: Offline

 Reply with quote  

Re: FOR NEXT LOOP QUESTION


quote:

OK (but can't think why anyone would consider it necessary).

If the point is to validate, one might as well validate. Why leave an exception?

Otherwise, save yourself some memory and use a string variable rather than a variant variable.
_________________
Regards,
Nate Oliver

Post Tue Dec 02, 2003 9:47 pm 
 View user's profile Send private message

Ponsy Nob.
Board Master


Joined: 26 Sep 2003
Posts: 472

Flag: Israel

Status: Offline

 Reply with quote  

Re: FOR NEXT LOOP QUESTION

quote:
Originally posted by NateO:

Otherwise, save yourself some memory and use a string variable rather than a variant variable.



How much memory would be saved?


Edited by NPO: Fixed Quote tags.

Post Wed Dec 03, 2003 12:08 pm 
 View user's profile Send private message

NateO
MrExcel MVP


Joined: 18 Feb 2002
Posts: 4311
Location: Minneapolis, Mn, USA
Flag: Usa

Status: Offline

 Reply with quote  

Re: FOR NEXT LOOP QUESTION

~ 6 bytes. icon_smile.gif

http://support.microsoft.com/default.aspx?scid=%2Fsupport%2Fexcel%2Fcontent%2Fvba101%2Fvbc5-2.asp
_________________
Regards,
Nate Oliver

Post Wed Dec 03, 2003 5:08 pm 
 View user's profile Send private message

Ponsy Nob.
Board Master


Joined: 26 Sep 2003
Posts: 472

Flag: Israel

Status: Offline

 Reply with quote  

Re: FOR NEXT LOOP QUESTION

quote:
Originally posted by NateO:
~ 6 bytes. icon_smile.gif

http://support.microsoft.com/default.aspx?scid=%2Fsupport%2Fexcel%2Fcontent%2Fvba101%2Fvbc5-2.asp


Would certainly want to make every effort and to take all possible steps to avoid unnecessarily using 6 bytes of memory.

Post Wed Dec 03, 2003 11:16 pm 
 View user's profile Send private message

NateO
MrExcel MVP


Joined: 18 Feb 2002
Posts: 4311
Location: Minneapolis, Mn, USA
Flag: Usa

Status: Offline

 Reply with quote  

Re: FOR NEXT LOOP QUESTION

Good Evening (here at least icon_razz.gif ),

quote:
Originally posted by Ponsy Nob.:

Would certainly want to make every effort and to take all possible steps to avoid unnecessarily using 6 bytes of memory.

Feeling argumentative? icon_mrgreen.gif

Ok, I'll bight. icon_smile.gif

First you want to trap for dates, but not a "false" string. Now you want to needlessly waste memory on your respective, subjective 'I don't care' non-validation scenario...

Why would one go out of their way to waste any amount of memory when it comes down to a very simple syntax choice?

There's no harm in getting into good coding habits, declaring variant variables [when you don't need to], or creating them from a lack of declaration is not one of these.

quote:
Originally posted by Microsoft:

The disadvantage is that variant variables require at least 16 bytes of memory, which can be significant in large procedures or complex modules.

_________________
Regards,
Nate Oliver

Post Wed Dec 03, 2003 11:34 pm 
 View user's profile Send private message

Ponsy Nob.
Board Master


Joined: 26 Sep 2003
Posts: 472

Flag: Israel

Status: Offline

 Reply with quote  

Re: FOR NEXT LOOP QUESTION

Why would you think that I'm being argumentative?

Did I not agree with you by posting :-
"Would certainly want to make every effort and to take all possible steps to avoid unnecessarily using 6 bytes of memory." ?

Or perhaps you really think that it's not worth making an effort to avoid using 6 bytes of memory?

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.)

Your statement "First you want to trap for dates" is not quite correct.
In fact, to satisfy the requirements of the OP I don't think it's necessary to do so, and Nimrod's suggested macro is a practical solution.
The only reason I mentioned dates in the first place was to correct the wrong information being posted about what input is allowed by specifying "Type1" input and to make it known that "Type1" accepts dates.

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

Post Thu Dec 04, 2003 3:08 pm 
 View user's profile Send private message

NateO
MrExcel MVP


Joined: 18 Feb 2002
Posts: 4311
Location: Minneapolis, Mn, USA
Flag: Usa

Status: Offline

 Reply with quote  

Re: FOR NEXT LOOP QUESTION

I thought you were being sarcastic.

I was still talking about Excel and VBA.

I don't understand any of this:


quote:

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:

quote:

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.
_________________
Regards,
Nate Oliver

Post Fri Dec 05, 2003 5:03 am 
 View user's profile Send private message

Ponsy Nob.
Board Master


Joined: 26 Sep 2003
Posts: 472

Flag: Israel

Status: Offline

 Reply with quote  

Re: FOR NEXT LOOP QUESTION


quote:
I thought you were being sarcastic.

Who me?


quote:
I don't understand any of this

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


quote:
How is this not relevant to Excel and VBA?

Did someone say it wasn't?


quote:
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?


quote:
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.


quote:
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.


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

Don't care about what?


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

Extreme overkill in my opinion.


quote:
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.

Post Fri Dec 05, 2003 10:38 am 
 View user's profile Send private message
  Display posts from previous:      

MrExcel Message Board Forum Index -> Excel Questions


Forum Jump:
Jump to:  

Post new topic   Reply to topic
Page 1 of 1



Add To Favorites

 


Forum Rules:
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Powered by phpBB: 2.0.4 © 2001 phpBB Group

Need help posting your first question? Read how to post

Need extra help ? Couldn't get the answer you needed ? Get a free quote from our Consulting Team

Download Colo's HTML Maker utility for displaying your Excel Worksheet on the board.

Download VB HTML Maker to post your code on the board


Check out our new index to 485 Excel Articles.


Return to MrExcel Consulting

All contents Copyright 1998-2004 by MrExcel.com
If you believe information posted here is from your copyrighted source, notify us per the Terms of Use
Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.