Microsoft Office Forums - View Single Post

blaisjoel · 04-17-2019, 05:06 AM

I want to be able to loop through my comboboxes using a variable (i)

This is what I have

Code:

   ElseIf ComboBox1.Value = "PICKUP" Then
        Load UnitForm
        UnitForm.Tag = 1
        UnitForm.Show
        TextBox1.Value = "8 cm high"
        TextBox2.Value = "33 cm high"
        TextBox3.Value = "7.5 cm high"

This is what I tried

Dim i as integer

ElseIf ComboBox & i.Value = "PICKUP" Then
Load UnitForm
UnitForm.Tag = 1
UnitForm.Show
TextBox1.Value = "8 cm high"
TextBox2.Value = "33 cm high"
TextBox3.Value = "7.5 cm high"

It doesn't like the variable.