Leath,
I figured it out - I just forgot to put the reference to I in the With
Me line below:
With Me(ComboBoxArray) should be:
With Me(ComboBoxArray(I))
Thanks for your help pointing me in the right direction!
- Brian
Code:
--------------------
Dim ComboBoxArray(1 To 3) As String
ComboBoxArray(1) = "cboTestA"
ComboBoxArray(2) = "cboTestB"
ComboBoxArray(3) = "cboTestC"
For I = 1 To UBound(ComboBoxArray)
With Me(ComboBoxArray(I))
If .MatchFound = False Then .Value = ""
End With
Next I
--------------------
I am getting a type mismatch on the With Me(ComboBoxArray) line.
Any thoughts?
thanks!
--
bntringa
------------------------------------------------------------------------
bntringa's Profile:
http://www.excelforum.com/member.php...o&userid=30523
View this thread:
http://www.excelforum.com/showthread...hreadid=505863