troubleshooting Question

Populate Combox Options from 1st column of multi column Range

Avatar of Rayne
RayneFlag for United States of America asked on
Microsoft OfficeMicrosoft Excel
6 Comments2 Solutions630 ViewsLast Modified:
Hello All,

I have a dynamic range - myRange, which has 3 columns. my issue is ...how can i get me combobox1 to populate fields from ONLY the first column of the myRange? I am using index to try to grab the first column but its not working....

Private Sub UserForm_Initialize()


ComboBox1.Value = ""

 
Dim Rng As Range
Dim Cel As Range
Set Rng = (Index(myRange, , 1))

For Each Cel In Rng
    ComboBox1.AddItem Cel.Value
Next

Set Rng = Nothing
Set Cel = Nothing


End Sub





myRange >>

item1        0         1
item2          1         0
item3          0         0
ASKER CERTIFIED SOLUTION
NorieAnalyst Assistant
Join our community to see this answer!
Unlock 2 Answers and 6 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 6 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros