Combo Box Help
I have a form which when loaded populates the value/text of cells , say A1
to A10 into a combo box using the additem method. Within this range off cells are duplicate entries and blank cells. I only want to add to the combo box one occurrence, and ignore blank & duplicate cells. For example if below, were cells A1 to A10, i only want to see John, Dave & Steve added once to the combo box. John John Dave Steve John Dave John Steve Thanks again Dave |
Combo Box Help
I have a form which when loaded populates the value/text of cells , say A1
to A10 into a combo box using the additem method. Within this range off cells are duplicate entries and blank cells. I only want to add to the combo box one occurrence, and ignore blank & duplicate cells. For example if below, were cells A1 to A10, i only want to see John, Dave & Steve added once to the combo box. http://www.j-walk.com/ss/excel/tips/tip47.htm This is for a ListBox, but it will work for a ComboBox with minor and obvious changes. HTH, Merjet |
All times are GMT +1. The time now is 10:05 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com