-gt;
Comes back or sets the worksheet range utilized to fill up the stipulated list box. Placing this residence damages any present checklist in the list box. Study/writeThread.
Jun 25, 2008 I then have a named range called RetainingWall containing a list of work types (brick,concrete etc) At the moment I want the formula to remove the space from Retaining Wall and dynamically look up the range named RetainingWall in the combo box The formula above won't allow me to enter 'test2' into the listfillrange of the combo box.
Syntax
reflection.ListFiIlRangephraseA variable that represents áControlFormatobject.AddItem method, this house comes back an clean thread (').
Remarks
Microsoft Excel states the material of every cell in the rangé and inserts thé mobile values into the list package. The checklist tracks changes in the range'beds tissue.
If the checklist in the checklist box had been made with theIllustration
This illustration adds a listing box to worksheet one and pieces the fill range for the list package.
Support and feedback
Have got questions or feedback about Workplace VBA or this documents? Please observe Office VBA support and feedback for guidance about the ways you can get support and offer responses.