ComboBox List Fill Range

  • Thread starter Thread starter Dan
  • Start date Start date
D

Dan

I want to use the text string that I have in cell ag2 as
the ListFillRange in a combobox.

How would I do that?
 
ComboBox1.RowSource = Range("Ag2").Value


Patrick Molloy
Microsoft Excel MVP
 
I am sorry to sound stupid but I cannot enter it into the
properties box under listfillrange - is there something I
should do or must this code be entered elsewhere?
 
Since you said listfillrange, assume this is an activeX (control toolbox
toolbar) Combobox on a Worksheet:

Put the code in the worksheet.Activate Event

Private Sub Worksheet_Activate()
me.Combobox1.ListFillRange = me.Range("AG2").Value
End Sub

Right click on the sheet tab and select View Code.

In the resulting module, in the left dropdown select Worksheet and in the
Right dropdown Select Activate

Put in code like the above.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

fill down and across range 1
How to Load Combo Box with Named Range 4
Can Listfillrange be used with a listbox or combobox on a form? 2
Fill combobox from data in different sheet 2
combobox 2
To Update ComboBox 3
named range 2
populate combobox from worksheet in different workbook 3

Back
Top