listfillrange

  1. B

    Copy a Combobox and change the linked cell and listfillrange

    I want to copy a template which contains a combo box from sheet "Change_Block" to the sheet "Scope_Changes" this will be one several times, so i don't know te combobox name upfront .. I tried this in a macro .... but the " With Selection" gives the run time error 438: Object doesnt support...
  2. R

    ListFillRange not staying in properties, but why?

    I have a table (called myDB) that I want to use as the source of content for an ActiveX listbox. I enter that name into the properties of the ListBox and as soon as I hit enter, "myDB" disappears from the ListFillRange field in the properties window. I've successfully done this many times...
  3. I

    Some problems with drop down list

    Hi. I have my code on a sheet called INFO I have the drop down box on a sheet called DATABASE In the name manager i have named it DATABASELIST & put the cell reference etc. When i click on the properties for the combobox2 i have entered under LinkedCell INFO!CG2 Under ListFillRange i have put...
  4. D

    Understand Validation Property for specifying another sheet in ComboBox list

    I'm using what is similar VBA I see in examples on the web of a ComboBox which looks at the validation in the cell and retrieves the list for the ComboBox. However, the code is designed for all the lists on the same worksheet. I have the lists on a different sheet. If I explicitly fill the...
  5. N

    Form Control List Box - Run-time error 438: Object doesn't support this property or method

    Hello! I'm trying to improve a workbook that uses VBA macros and I have no experience with VBA. I've studdied the current excel workbook and vba code to help me. I've been learning about vba and I've been able to sort out some problems but now I have no idea what's causing my error. Btw, the...
  6. Carly

    Updating ComboBox ListFillRange

    I have a report template which contains a combobox which has a ListFillRange which is a Named Range. The combobox has a OnChange macro which kicks in when the end user selects an option from the combobox. The problem I have is every month the report changes & I have to refresh the values in the...
  7. T

    how to fill the Listfillrange, in an activeX combobox with an dynamic range

    I have multiple comboboxes, all of them need to be filled with the same set of data in an collumn an another sheet. Normaly I would use a range in the Listfillrange box of the properties window. For example Sheet1!A1:A25 But in this case the list will expand or shorten in the future and I...
  8. D

    ListfillRange help

    How do I code this: listbox1.listfillrange = "Sheet1!A1:A20" into this: listbox1.listfillrange = "Sheet1!A1:A" & num where num is the number of data rows.
  9. R

    Issue with listbox using dynamic range as listfillrange

    Hello, Here is the workflow I'm trying to achieve and where my problem arises: 1. I select option A, B, or C from a group of option buttons. 2. Based on my selection, a dynamic range, dictated by the OFFSET function, is displayed in a listbox. 3. My listbox is a multi-selection listbox, so I...
  10. D

    Combobox ListFillRange

    Is it possible to use the Combobox ListFillRange to list values from two groups of cells? For example, in column 'A', I have the values, 1,2,3; and in Column 'B', I have the values, A, B, C. I want to list the values in column 'A' along with the value of say, B, in Column 'B'...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top