Combo Box

David

New Member
Joined
Apr 22, 2002
Messages
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?
 

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).
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
 
Upvote 0
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.
 
Upvote 0
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?
 
Upvote 0

Forum statistics

Threads
1,213,536
Messages
6,114,202
Members
448,554
Latest member
Gleisner2

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