Hey Dan.. thanks for the video on looping through many user form controls. The advice on using Me.Controls("ControlName" & CounterVariable) to loop through them incrementally with a counter variable is great advice and can be put to good use in many ways. Nice tip.. keep them coming. Thanks and Thumbs up!
Very nice indeed. Thank you for the video. Just a question. How do you loop though a sheet control (command button). I.e. if i have 100 active command buttons in sheet1 and only want certain buttons to change colour based on a set value. Really will appreciate the help
Hello Sir, please help me to do this project: Lets assume, you are a Cable Operator. You have over 2000 customers' Names, Email IDs, Phone Numbers, Package Names, Start Dates and End Dates in a Excel file named "Customer Details". Every customer has unique start dates and end dates. (For Example : Package of Customer A will end in 5th February, 2019; package of Customer B will end in 9th February, 2019 and package of Customer C will end in 20th February, 2019.) Now you have to send sms to the phone numbers of those customers via Outlook automatically, whose end dates are 3 days away from the current date. How do I do all these things through VBA in Excel?
Hey Dan.. thanks for the video on looping through many user form controls. The advice on using Me.Controls("ControlName" & CounterVariable) to loop through them incrementally with a counter variable is great advice and can be put to good use in many ways. Nice tip.. keep them coming. Thanks and Thumbs up!
Very nice indeed. Thank you for the video. I have a question? if there are 2 userforms how to change this code?
Glad to see back
Very nice indeed. Thank you for the video. Just a question. How do you loop though a sheet control (command button). I.e. if i have 100 active command buttons in sheet1 and only want certain buttons to change colour based on a set value. Really will appreciate the help
hi... incredible explaination... where i can find this workbook please...
Very helpful! Those 3 haters (3dislikes) above are just noob!!
Thank you so much
Its very helpful to me
Is it worth to invest time to learn VBA in 2019, with all the available tools ie PowerQuery, Ppivot etc?
Good Question!!
Hello Sir, please help me to do this project:
Lets assume, you are a Cable Operator. You have over 2000 customers' Names, Email IDs, Phone Numbers, Package Names, Start Dates and End Dates in a Excel file named "Customer Details". Every customer has unique start dates and end dates. (For Example : Package of Customer A will end in 5th February, 2019; package of Customer B will end in 9th February, 2019 and package of Customer C will end in 20th February, 2019.)
Now you have to send sms to the phone numbers of those customers via Outlook automatically, whose end dates are 3 days away from the current date.
How do I do all these things through VBA in Excel?
Lots of controls on that form... wow. Good job explaining that. LOL.