Excel - combo box value

Where can I put the "value" direct in the properties setting instead of
putting a range name? How should I input the value in "ListFillRange"?

  JLGWhiz replied to Seeker

You can use the AddItem method or the List method.  See VBA help topics for
details using those keywords in the search box for each method.

  JLGWhiz replied to Seeker

You might also find this site helpful.

http://support.microsoft.com/kb/161598

  Seeker replied to JLGWhiz

Thank you.

fill a listbox with one m x n range values? thanks, Emiliano Excel Programming Discussions VBA (1) ListFillRange (1) Makesure (1) Emiliano (1) Joes (1) Triangle (1) Listbox (1) Toolbar (1) You must can right click on the Listbox to add ranges by Right Click on Listbox - Properties - ListFillRange. Enter something like A1:A10. to Add a Listbox or change ListFillRange do the following 1) Use toolbar "Control Toolbox". If you don't have one then t do this then you are not in Design Mode. Click the triangle again 4) ListFillRange. Enter something like A1:A10. 5) Press Triangle again to exit Design Mode. Sorry Joes user form. Thanks, Emiliano You can do it two ways. 1) Manual - go to the VBA menu and view properties window and in RowSource box add something like sheet1!A1:A10

list box to the control tool bar list box? Or do I need to know VBA to referrence the cell link? Excel Miscellaneous Discussions VBA (1) ListFillRange (1) PropertiesEnter (1) LinkedCell (1) Subscribers (1) Max (1) Equivalents (1) Xdemechanik (1) In design mode, Right-click on it (ie the List Box) > Properties Enter as required for: ListFillRange, LinkedCell (these are the equivalents) - - Max Singapore http: / / savefile.com / projects / 236895 Downloads:20, 500 listbox click on the properties icon on that control toolbox toolbar. Look for LinkedCell and ListFillRange in that properties window. Remember to leave design mode when you're finished. - - Dave Peterson you Make sure that the linkedcell is empty or one of the values in the listfillrange. - - Dave Peterson Thanks! It looks all right now but is there something I have to list box to the control tool bar list box Or do I need to know VBA to referrence th

Limiting Input Range using VBA Excel I am trying to set the InputRange of a combobox on a sheet (not using a form) via vba. I thought the following code would work, but I get a space between the last number of rows not empty s = "I13:I" & Str(i) Worksheets("Estimate").Shapes("cboMultSize").ControlFormat.ListFillRange = s For example, if i = 2, then s turns out to be "I13:I 15 need this to be Thanks. Excel Programming Discussions ControlFormat (1) Worksheets (1) Shapes (1) ControlFormat.ListFillRange (1) VBA (1) VB (1) Sheet8.Range (1) CboMultSize (1) The Str function always output a leading I" & i - - Dave Peterson Thanks Rick, the CStr worked perfectly. keywords: Limiting, Input, Range, using, VBA description: I am trying to set the InputRange of a combobox on a sheet (not using a form) via vba. I thought the following code would work, but I get a space betwee

ComboBox ListFillRange Excel Hi All, Why a horizontal range, e.g like A1:G1 cannot be used in ComboBox ListFillRange? Is there a workaround for that? Another question: can an OFFSET function or a named range be used in ComboBox ListFillRange? Thanks, Stefi Excel Miscellaneous Discussions Intersect (1) Excel (1) ActiveSheet.Range (1) Named range (1 Worksheet (1) Workbook (1) OFFSET (1) Macro (1) You could always populate the combobox's listfillrange in code with .additem or .list (and return the transposed .value of the range): Me Transpose(Me.Range("a1:c1").Value) And you could use a defined name as the listfillrange, but I think you'll have to use another name to do the offset() stuff. - - Dave Peterson Thanks Dave, I tried to use a defined name as the listfillrange, but it works only if the defined name refers to a vetical range, otherwise the Thanks, Stefi „Stefi” ezt írta: Did you try to set the combobox's listfillrange manually? If yes, then clear that out- -either manually or via code. me.combobox.listfillrange = "" - - Dave Peterson Bingo, that was the trick! Tell me please, how can one get such