ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   avoiding doubles in a combobox (https://www.excelbanter.com/excel-programming/394396-avoiding-doubles-combobox.html)

Bart

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

John Bundy

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


Dave Peterson

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

Bart

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



All times are GMT +1. The time now is 01:14 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com