I am using the solution from the article "How to use a constructed string to reference a combobox" to return a control (Name) for text boxes and list however I have hit a problem when trying to use this method for an array of checkboxes. In the code below the control is found however c is then set to 0, the index of the control I think, not the name of the control.
Public Function getControlByName(ByVal controlName As String) As Control
Dim c As Control
For Each c In MyFrm.Controls
If c.Name = controlName Then
Set getControlByName = c
MsgBox controlName, vbCritical, "No matching control found"