The code below works ok if named user form isn't open-active. If I was to create a button in that user form with below code to execute when button pushed, I receive an error at line
"For Each CNTRL In ThisWorkbook.VBProject.VBComponents(FormName).Designer.Controls"
Error: "Object variable or with block variable not set"
Again, code works perfect if run with form closed; not when actively opened.
Need to work with form opened.
Please Login or Register to view this content.
Bookmarks