chamdan
04-25-2012, 05:50 PM
Hi,
I created a Userform where a comboBox is located and have inserted in the property of the ComboBox in RowSource = [range name] where range name is AD3:AD2000 and have given the name of the range as "IssuesQ" now the Rowsource contains:
RowSource=IssuesQ
But when I load the form and click on the ComboBox it list all the names I want however it inserts even the blank row cells available in the column. How can I make it work to remove all balnk lines from the ComboBox?
Thanks for your help
Chuck
I created a Userform where a comboBox is located and have inserted in the property of the ComboBox in RowSource = [range name] where range name is AD3:AD2000 and have given the name of the range as "IssuesQ" now the Rowsource contains:
RowSource=IssuesQ
But when I load the form and click on the ComboBox it list all the names I want however it inserts even the blank row cells available in the column. How can I make it work to remove all balnk lines from the ComboBox?
Thanks for your help
Chuck