Loop Through UserForm Controls Dynamically - Excel VBA Is Fun

[@hazhirk148]

Very nice indeed. Thank you for the video. I have a question? if there are 2 userforms how to change this code?

[@francoispetrus8478]

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

[@wayneedmondson1065]

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!

[@edayers315]

Glad to see back

[@awadhbinamro948]

hi... incredible explaination... where i can find this workbook please...

[@Abdulaziz-el4jm]

Is it worth to invest time to learn VBA in 2019, with all the available tools ie PowerQuery, Ppivot etc?

[@sajidghanchi7591]

Thank you so much

[@sajidghanchi7591]

Its very helpful to me

[@arielzabatecuizon5147]

Very helpful! Those 3 haters (3dislikes) above are just noob!!

[@automationguide3498]

Good Question!!

[@kartickchakraborty7948]

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?

[@krn14242]

Lots of controls on that form... wow. Good job explaining that. LOL.