0

Im using VBA build inside excel
is there a way to find if ComboBox has a value?
for example
i have 80 ComboBox and i want to check if they have a value like "A", "B", "C" and "D"
and if the value is blank like "" then stop the checking.

2
Contributors
3
Replies
6
Views
4 Years
Discussion Span
Last Post by ImZick
0

Im thinking something like this
but surely it doesn't work

Public Sub Test()
Dim ComboBox As String
Dim i As Long

    For i = 1 To 80 
        If ComboBox & i.Text = "Level 4" Then
            Range("S8") = "0.12"
        End If
    Next

End Sub

0

You are almost on the right track. :) Try the following...

Public Sub Test()
Dim cmbMyBox As ComboBox ''Do Not use ComboBox, it is a reserved name for ... combobox

Dim i As Integer
    For i = 1 To 80 
        If cmbMyBox(i).Text = "Level 4" Then ''Assuming that you have an array of 80 combo's
            Range("S8") = "0.12"
        Elseif cmbMyBox(i).Text = "" Then
            Exit Sub ''Exit and do something...
        End If
    Next
End Sub
0

I got an error
Object variable or With block variable not set

and it highlight this code

        If cmbMyBox(i).Text = "Level 4" Then ''Assuming that you have an array of 80 combo's
This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.