| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ComboBox List Fill Range
I want to use the text string that I have in cell ag2 as
the ListFillRange in a combobox. How would I do that? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
ComboBox List Fill Range
ComboBox1.RowSource = Range("Ag2").Value
Patrick Molloy Microsoft Excel MVP -----Original Message----- I want to use the text string that I have in cell ag2 as the ListFillRange in a combobox. How would I do that? . |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
ComboBox List Fill Range
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? -----Original Message----- ComboBox1.RowSource = Range("Ag2").Value Patrick Molloy Microsoft Excel MVP -----Original Message----- I want to use the text string that I have in cell ag2 as the ListFillRange in a combobox. How would I do that? . . |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
ComboBox List Fill Range
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. -- Regards, Tom Ogilvy wrote in message ... 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? -----Original Message----- ComboBox1.RowSource = Range("Ag2").Value Patrick Molloy Microsoft Excel MVP -----Original Message----- I want to use the text string that I have in cell ag2 as the ListFillRange in a combobox. How would I do that? . . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Fill a Combobox from a ROW? | Excel Discussion (Misc queries) | |||
| fill combobox depending on selection from another combobox | Excel Discussion (Misc queries) | |||
| .AddItem list and populating combobox with created list | Excel Discussion (Misc queries) | |||
| Show one range in a combobox and write the 2nd range! | Excel Programming | |||
| missing items in sheet's activex list/combobox after resizing range | Excel Programming | |||
Linear Mode
