Celebrate National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

Solved

Populate Combobox Values at a click of button

Posted on 2011-03-05

1 solution

Medium Priority

639 Views

Last Modified: 2012-05-11

I want to populate the Combobox with the list of predefined values declared in another sheet in same excel at a click of command button

Comment

Question by:srikanthv2322

[X]

Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

Help others & share knowledge
Earn cash & points
Learn & ask questions

Join The Community

4 Comments

LVL 30

Accepted Solution

by:SiddharthRout

SiddharthRout earned 2000 total points

ID: 350448042011-03-05

Please amend as applicable.

Private Sub CommandButton1_Click()
    '~~> This will populate from Row 1 to Row 10
    '~~> from Col A in Sheet 2
    For i = 1 To 10
        ComboBox1.AddItem Sheets("Sheet2").Range("A" & i).Value
    Next
End Sub

Open in new window

Sid

LVL 14

Expert Comment

by:Zack Barresse

ID: 350450242011-03-05

I would amend Sid's code to include a clear functionality, which will not make your list "double" when you click the button a second time...

Private Sub CommandButton1_Click()
    Dim i As Long
    ComboBox1.Clear
    For i = 1 To 10
        ComboBox1.AddItem Sheets("Sheet2").Range("A" & i).Value
    Next
End Sub

Open in new window

Or, you can use another method, one I prefer, to enter the data all at once instead of looping (I hate looping)...

Private Sub CommandButton1_Click()
    ComboBox1.Clear
    ComboBox1.List = Sheets("Sheet2").Range("A1:A10").Value
End Sub

Open in new window

HTH

LVL 30

Expert Comment

by:SiddharthRout

ID: 350450282011-03-05

Thanks Zack

I missed on "ComboBox1.Clear". Nice catch!

Yeah, I completely agree with you on "Looping".

Sid

LVL 14

Expert Comment

by:Zack Barresse

ID: 350450542011-03-05

Just another way to skin the cat. I'm not really sure what the OP's end-game is with this particular query, which is why I posted the secondary routine. It may in fact be a loop is what is called for - I have no idea! :)

Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Spreadsheet Compare 2016 does not work with 64 Bit Office 2016

Article by: Stacy

How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016

Automating Microsoft Excel from Access (Part II)

Article by: Dale Fye

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.

Creating an Efficient Dashboard in Excel

Video by: Katie

Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…