Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Array formula with and/or statements | Excel Discussion (Misc queries) | |||
Too Many IF Statements Nesting Error (Excel Formula Loop w/o VBA) | Excel Worksheet Functions | |||
Need loop structure to get round limited IF statements | Excel Discussion (Misc queries) | |||
Updating For Loop statements | Excel Programming | |||
variant array containing cel adresses convert to actual ranges-array | Excel Programming |