Naming A Cell, Range Or Object With The Name Box The easiest way to name a cell, range or object like a chart is using the Name Box Select your cell, range or object and type a name into the Name Box then hit Enter on the keyboard Names can't contain spacesIn the Name Manager dialog box, select the range name you want to resize it, and then click the button 3 In the Name Manager – Refers to box, select a new range for this range name, and then close this box 4 Follow the steps below to load the table list into the combo box Create a blank form Click on the Combo Box icon Click on a Cancel button to cancel the Combo Box Wizard 4 Double click on combo box to open the Property Sheet 5 Change Row Source Type to Value List under the Data tab of Combo box property 6
The Vba Guide To Named Ranges Thespreadsheetguru
