Merry Christmas everyone. I hope God blesses you richly this upcoming year. Remember, you ARE a success!! Believe it, be it! Blessings my friends!! Dan
no equation. Check out my video on loops by searching on my channel. But when you create a 'FOR/NEXT' loop, you say For X = (starting number) to (ending number) 'put your code here that involves the escalating variable, in this case x then add Next x at the bottom. Everything in between the FOR part at the top and the NEXT part at the bottom happens over and over again until x has exceeded the ending number.
Good night in cycle in vba for next I want in a loan system to bring me the installments daily modality, example 20 installments that start on 01-10-22 and I want 20 installments but exclude Sundays and the 20 installments are fulfilled, what would be the code
One question: I have different frequency types (e.g: semi-annual, every 3 months). Is there any work around to use these frequencies with the DateAdd function?
How was the meaning of the word "Quarter" captured by the table of text? Are the values in the explanation column actual values in VBA? (like "true" for example?) Thanks for the great vids!
i try to make a comment before Debug.Print stdate, however, there is no response from immediate window, why is it? So next time to make immediate window works, i need to include Debug.Print in my code?
![BLACK BAG - Official Trailer [HD] - Only in Theaters March 14](http://i.ytimg.com/vi/Du0Xp8WX_7I/mqdefault.jpg)
Thanks for all your videos!!
Merry Christmas everyone. I hope God blesses you richly this upcoming year. Remember, you ARE a success!! Believe it, be it! Blessings my friends!! Dan
Super Super Super Super 😘😘😘😘👍👍👍👍
Only you tell me how to add dates
Found exactly
thank you
no equation. Check out my video on loops by searching on my channel. But when you create a 'FOR/NEXT' loop, you say For X = (starting number) to (ending number)
'put your code here that involves the escalating variable, in this case x
then add Next x at the bottom.
Everything in between the FOR part at the top and the NEXT part at the bottom happens over and over again until x has exceeded the ending number.
This is magic. What I am looking for. Thanks
Yen-Moy Yap I'm so glad it helped! Thanks for letting me know. Dan
to put stDate to equal a date value you put tow # around the date expression:
Example: stDate = #12/31/2005#
good luck
Awesome, great tip Mohammad!
:)
Good night in cycle in vba for next I want in a loan system to bring me the installments daily modality, example 20 installments that start on 01-10-22 and I want 20 installments but exclude Sundays and the 20 installments are fulfilled, what would be the code
One question:
I have different frequency types (e.g: semi-annual, every 3 months). Is there any work around to use these frequencies with the DateAdd function?
Powerful function. Thanks!
How was the meaning of the word "Quarter" captured by the table of text?
Are the values in the explanation column actual values in VBA? (like "true" for example?)
Thanks for the great vids!
Hi Dan, Working with Dates gives an error on my vba macbook. How do i get my vba to recognise the dates?
i try to make a comment before Debug.Print stdate, however, there is no response from immediate window, why is it?
So next time to make immediate window works, i need to include Debug.Print in my code?