Checking selection of the CheckBox and TextBox in Idea with loop

Hi bluecox,

For question number 1 unfortunately there is no short way that I know of.  If the item name is within double quotes then you can use a loop to populate but when you are trying to extract the information you are accessing the object directly so there is no way that I know of to be able to get it through a loop.  If you figure one out please let me know as I have tried from time to time over the years to figure out a way.

For question 2, the reason you are never getting litigation or crime is the way that the compif function works.  It is based on the order of your items, so when you run it will first test if money is in the field, if so it doesn't test anything else as it has found it.  When it tests "" (nothing), for whatever reason, the compif always returns true so when it tests the third item it returns true and stops there and will return a blank (nothing).  To get around this problem you need to test if a word is present and if not then not include it in your equation.  Here is an example that I did that hopefully will help you out.  You will also see I did a loop to make the writing of the equation easier.

Option Explicit

Sub Main
	Dim eqn As String
	Dim UserSpecificWord(12) As String
	Dim UserChoice(8) As String
	Dim i As Integer
	
	UserChoice(8) = "MY_FIELD"
	UserSpecificWord(0) = "money"
	UserSpecificWord(1) = "transfer"
	UserSpecificWord(11) = "litigation"
	UserSpecificWord(12) = "crime"
	
	eqn = "@CompIf("  'add the beginning of the equation
	For i = 0 To UBound(UserSpecificWord)
		If UserSpecificWord(i) <> "" Then 'test to make sure that a user has entered a word, if not skip it.
			eqn = eqn & " @Isini(""" & UserSpecificWord(i) & """, " & UserChoice(8) & "), """ & UserSpecificWord(i)  & ""","
		End If
	Next i
	eqn = eqn & " 1, """")" 'add the ending of the equation
	MsgBox eqn
End Sub

Thank you Brian, I believe your code will take me into the right direction to improve my (it is working now but with your suggestion it will be more efficient and smarter).
With regards to my first question , the fundamental problem here could be the fact that in Idea the collection of objects is treated differently than in VB - checkboxed , listboxes etc. are considered to be a dialog controls but i havent found any indication that all of them fall into one group of clearly defined objects so using loop for ... next would be easily possible.
I might be wrong with my assumption so happy to hear from other users who tried to tackle it already. 
Anyway i will explore it further and will come back with any solution i might find to share here.
 
Many thanks

Thank you Brian,
I believe your code will take me into the right direction to improve my existing code (it is working now but with your suggestion it should be more efficient and smarter).
 
With regards to my first question , the fundamental problem here could be the fact that in Idea the collection of objects is treated differently than in VB - checkboxes,textboxes , listboxes etc. are considered to be a dialog controls but i havent found any indication that all of them fall into one group of clearly defined objects so using loop for ... next to loop through the group (collection) of the elements of the same higher category would be easily possible.
I might be wrong with my assumption so happy to hear from other users who tried to tackle it already. 
Anyway i will explore it further and will come back to share it here with any solution that I might find.
 
Many thanks

Hi Brian,
Just wanted to say a big thank you for your suggestion and code. After a few adjustments it works like a charm.