Combobox

AllenL · Mar 25th, 2002, 12:49 PM

Hello
Does anyone know how to add a column of items to the combobox alphabatically and elimate the duplicated ones?
Thanks in advance

AllenL · Mar 25th, 2002, 02:24 PM

Can someone please help me...
This should be a common application right
Some hint will very helpful too
Thanks in advance

dk · Mar 25th, 2002, 02:31 PM

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

AllenL · Mar 26th, 2002, 06:01 AM

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

AllenL · Mar 26th, 2002, 06:08 AM

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

paelinck · Mar 26th, 2002, 06:20 AM

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

Dave Hawley · Mar 26th, 2002, 06:28 AM

Hi Allen

I think this will be just what you need.

http://www.ozgrid.com/VBA/UserForms.htm

AllenL · Mar 26th, 2002, 06:55 AM

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

nisht · Mar 26th, 2002, 07:00 AM

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
nishith desai

[ This Message was edited by: nisht on 2002-03-26 06:03 ]

AllenL · Mar 26th, 2002, 07:46 AM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 25th, 2002, 12:49 PM	#1
AllenL Board Regular Join Date: Mar 2002 Posts: 67	Hello Does anyone know how to add a column of items to the combobox alphabatically and elimate the duplicated ones? Thanks in advance

Mar 25th, 2002, 02:24 PM	#2
AllenL Board Regular Join Date: Mar 2002 Posts: 67	Can someone please help me... This should be a common application right Some hint will very helpful too Thanks in advance

Mar 25th, 2002, 02:31 PM	#3
dk MrExcel MVP Join Date: Feb 2002 Location: Sydney, Australia Posts: 2,908	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

Mar 26th, 2002, 06:01 AM	#4
AllenL Board Regular Join Date: Mar 2002 Posts: 67	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

Mar 26th, 2002, 06:08 AM	#5
AllenL Board Regular Join Date: Mar 2002 Posts: 67	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

Mar 26th, 2002, 06:20 AM	#6
paelinck Board Regular Join Date: Mar 2002 Location: Leiden, The Netherlands Posts: 68	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

Mar 26th, 2002, 06:28 AM	#7
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	Hi Allen I think this will be just what you need. http://www.ozgrid.com/VBA/UserForms.htm

Mar 26th, 2002, 06:55 AM	#8
AllenL Board Regular Join Date: Mar 2002 Posts: 67	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

Mar 26th, 2002, 07:00 AM	#9
nisht Board Regular Join Date: Feb 2002 Location: Ahmedabad Gujarat Posts: 303	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 nishith desai [ This Message was edited by: nisht on 2002-03-26 06:03 ]

Mar 26th, 2002, 07:46 AM	#10
AllenL Board Regular Join Date: Mar 2002 Posts: 67	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