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?
the ListFillRange in a combobox.
How would I do that?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
P
Patrick Molloy
ComboBox1.RowSource = Range("Ag2").Value
Patrick Molloy
Microsoft Excel MVP
Patrick Molloy
Microsoft Excel MVP
G
Guest
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?
properties box under listfillrange - is there something I
should do or must this code be entered elsewhere?
T
Tom Ogilvy
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.
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.