Combo Box

David · Apr 23rd, 2002, 10:19 AM

I am trying to select text out of a combo box and populate another cell with that text. But when I do that all I get is a number, is there any way to get the text value to populate another cell?

Audiojoe · Apr 23rd, 2002, 10:22 AM

So you want whatever you pick from a combobox to appear in a cell? Whatever cell you want it to go into, use this code:

worksheets("sheetnamehere").range("cellreferencehere").value = combobox1

That's assuming your combobox is called combobox1. You need to paste this into your combobox's change event. To get there go into VB editor and double click the combobox on your userform design

Audiojoe

[ This Message was edited by: Audiojoe on 2002-04-23 09:24 ]

Aladin Akyurek · Apr 23rd, 2002, 10:23 AM

Quote:

On 2002-04-23 09:19, David wrote:
I am trying to select text out of a combo box and populate another cell with that text. But when I do that all I get is a number, is there any way to get the text value to populate another cell?

In the target cell enter:

=INDEX(input-range,cell-link)

where input-range is the range the ComboBox uses and cell-link is is its Cell link.

David · Apr 23rd, 2002, 10:26 AM

Thanks a bunch guys, it works.
Cheers

itsmewhoelse · Apr 23rd, 2002, 11:22 AM

Newbie needs someone to hold his hand...
I am trying to create a combo box or? to enable the user to pick from a list. I have created a sheet with all data in seperate columns, but in the same workbook. I have tried both of the aforementioned methods, but, I just don't get it. Step-by-step anyone?

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

Apr 23rd, 2002, 10:19 AM	#1
David New Member Join Date: Apr 2002 Posts: 2	I am trying to select text out of a combo box and populate another cell with that text. But when I do that all I get is a number, is there any way to get the text value to populate another cell?

Apr 23rd, 2002, 10:22 AM	#2
Audiojoe Board Regular Join Date: Feb 2002 Location: Where the wild roses grow Posts: 285	So you want whatever you pick from a combobox to appear in a cell? Whatever cell you want it to go into, use this code: worksheets("sheetnamehere").range("cellreferencehere").value = combobox1 That's assuming your combobox is called combobox1. You need to paste this into your combobox's change event. To get there go into VB editor and double click the combobox on your userform design Audiojoe [ This Message was edited by: Audiojoe on 2002-04-23 09:24 ]

Apr 23rd, 2002, 10:26 AM	#4
David New Member Join Date: Apr 2002 Posts: 2	Thanks a bunch guys, it works. Cheers

Apr 23rd, 2002, 11:22 AM	#5
itsmewhoelse New Member Join Date: Apr 2002 Location: Atlanta,Ga Posts: 7	Newbie needs someone to hold his hand... I am trying to create a combo box or? to enable the user to pick from a list. I have created a sheet with all data in seperate columns, but in the same workbook. I have tried both of the aforementioned methods, but, I just don't get it. Step-by-step anyone?