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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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