Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 25
Default Duplicate row source of combobox (code pls.)

I have a combo box that contains value from a certain column of a worksheet.
That column has duplicate values.example:
Teacher
aa
bb
cc
dd
ee
ff
aa
cc
ee


What i want is for those duplicates not to appear in the combobox list.
Could Anyone help me pls.
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6,953
Default Duplicate row source of combobox (code pls.)

See John Walkenbach's page on this topic:

http://www.j-walk.com/ss/excel/tips/tip47.htm

--
Regards,
Tom Ogilvy


"Chinx21" wrote:

I have a combo box that contains value from a certain column of a worksheet.
That column has duplicate values.example:
Teacher
aa
bb
cc
dd
ee
ff
aa
cc
ee


What i want is for those duplicates not to appear in the combobox list.
Could Anyone help me pls.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
ComboBox Row Source across ALL sheets Corey Excel Programming 6 July 8th 06 04:58 AM
ComboBox Row Source across ALL sheets Corey Excel Programming 11 July 4th 06 06:57 AM
Combobox source yohann Excel Programming 1 March 6th 04 02:18 PM
combobox row source scrabree Excel Programming 1 October 15th 03 08:52 PM
Combobox list source Chris Thompson Excel Programming 3 August 26th 03 02:18 AM


All times are GMT +1. The time now is 02:51 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"