Loop through all the controls of Userform

     

  • Though this code user can loop through all the controls which exists on USERFORM
  • It displays all the control Names on Message box

    •  

    Sub Loop_Through_All_The_Controls_In_Userform()
    Dim ctr As Control
    For Each ctr In UserForm1.Controls
    MsgBox ctr.Name
    Next
    End Sub

    Download The Workbook

     

     

Hi Everyone,
Welcome to VBA Macros Tutorial. This Tutorial provides comprehensive knowledge on VBA Macros to the user. Hope it enhances your coding skills. If you like this web page kindly Share this to your near and dear. I Prepared this content as per my level of knowledge, if any changes required kindly bring to my notice. Thanks for visiting this web page

Thanks,
Pavan Kumar Gundlapalli