Combobox Looping

blaisjoel · #1 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.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Looping through emails	knarfreppep	Outlook	2	04-07-2018 08:03 AM
Looping several slides	gabby	PowerPoint	11	04-25-2015 03:05 AM
Need help on macro for looping	kilosub	Word VBA	31	07-27-2011 01:37 PM
Looping Question	Steve B	PowerPoint	0	01-19-2011 10:44 AM
Looping video	tomasball	PowerPoint	0	10-30-2010 02:38 PM