I have a combobox in my excel spreat sheet. I want to use a macro to fill the combobox with data. In the format Control option dialog I want to use a macro in InputRange field. BUt i am not able to use a macro for this. Any help is appreciated.
Controls from the Control Toolbox are different from the old Excel controls (Forms Toolbar).
Activate the Control Toolbox and click the Design icon (top left). Right click your combo box and choose Properties. Set the ListFillRange property eg A1:A10 and close the Properties window. Click the Design icon again to exit design mode.