Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 21
Default avoiding doubles in a combobox

Hi there,

I would like to know how to check the content of a combobox to avoid doubles
in the list.
Can anyone help me with this?
Thanks in advance!

Greets,
Bart
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 772
Default avoiding doubles in a combobox

look into the MatchFound property returns true or false for whether the item
exists, additem if it does not ignore if it does.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"Bart" wrote:

Hi there,

I would like to know how to check the content of a combobox to avoid doubles
in the list.
Can anyone help me with this?
Thanks in advance!

Greets,
Bart

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 35,218
Default avoiding doubles in a combobox

Maybe you can take some ideas from John Walkenbach:
http://j-walk.com/ss/excel/tips/tip47.htm

Bart wrote:

Hi there,

I would like to know how to check the content of a combobox to avoid doubles
in the list.
Can anyone help me with this?
Thanks in advance!

Greets,
Bart


--

Dave Peterson
  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 21
Default avoiding doubles in a combobox

Thanks!
I will try this one!


"John Bundy" wrote:

look into the MatchFound property returns true or false for whether the item
exists, additem if it does not ignore if it does.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"Bart" wrote:

Hi there,

I would like to know how to check the content of a combobox to avoid doubles
in the list.
Can anyone help me with this?
Thanks in advance!

Greets,
Bart

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
how do i get rid of doubles from my database? Bill Excel Discussion (Misc queries) 2 April 27th 10 07:55 AM
Summarizing doubles Sippan Excel Worksheet Functions 1 June 17th 08 09:05 AM
Sorting doubles rbrunz Excel Discussion (Misc queries) 1 June 13th 08 04:20 PM
Loading Combobox, but avoiding duplicates Dan Excel Programming 2 May 8th 07 06:15 PM
Comparing Doubles big t Excel Programming 1 September 20th 04 10:16 AM


All times are GMT +1. The time now is 12:23 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"