i am building a helper application that runs custom queries. The problem is, there are like 60 "select" queries and each of them takes time to execute. So now I have put several check boxes which will filter which queries to execute and skip unwanted ones.
I can name my check boxes with some text and numbers, but since I am noob VBA programmer I am not sure how to make a check box name at runtime and reference the appropriate one.
If I do it manually I will need to add 60 lines of this
How can I reference my check boxes at run-time with code?Code:chkbox1.Value = True chkBox2.Value = False . . . chkBox60.Value = False




Reply With Quote
