Combobox

AllenL

Board Regular
Joined
Mar 14, 2002
Messages
67
Hello
Does anyone know how to add a column of items to the combobox alphabatically and elimate the duplicated ones?
Thanks in advance
 

Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.
Can someone please help me...
This should be a common application right
Some hint will very helpful too
Thanks in advance
 
Upvote 0
Do you want to use VBA? Which combobox are you using - the one from the Control Toolbox or one from Forms? Is the data in one column or more?

D
 
Upvote 0
I want to use VBA, and I have 4 columns of data. So I guess I have to use 4 comboboxs.
Can you help me out?
Thanks in advance
 
Upvote 0
The purpose of my combobox is to show all the different data in a column and for user to type in the data. After the user has the data in the combobox, the user can search the data in the column.
I have already done the search part. Right now, I just need the combobox to show all the data.
Thanks in advance
 
Upvote 0
My suggestion would be to use the Advanced Filter in the Data menu to select unique items (select "Unique records only" and save results in a new location), and then to sort the resulting list. You can then use this list als input range for your combo box(es).

Marc
 
Upvote 0
Hello Dave
The example you have doesn't use the combobox and the user is not allow to type in the textbox.
I found a couple of combobox examples, and I follow its instruction(basically, changing the property of the combobox). It is almost working now. The only problem I have is that it shows all the duplicated data and the scroll bar can't scroll.
Can you help me out
Thanks in advance
 
Upvote 0
Friend,
I suppose file nos.
16,18,22,23

if fact file nos 22 will give the help what exactly you are asking for and about showing the columns.. i suppose file nos 23 can be more useful to you.
http://www.pexcel.com/download.htm
from my download section can be helpful to you
ni****h desai
This message was edited by nisht on 2002-03-26 06:03
 
Upvote 0
Hello nisht
I tried the examples you have but I still can't get my scroll bar move nor elimate the duplicated data. I downloaded file no.22, however, the file is damaged and I can't open it
Any more help will be very appreciated
Thanks in advance
 
Upvote 0

Forum statistics

Threads
1,213,517
Messages
6,114,089
Members
448,548
Latest member
harryls

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top