combo box problem

jimmywanna · Mar 19th, 2002, 08:39 AM

I have made a combobox which lists wards which medication is to be sent to. I need to know how:
when the user clicks on one of the 10 ward which drop down from the combo box, this then appears in another cell.
So far i can only manage (using the help) to get it to return a number which relates to the position in the drop down list which is clicked. i need it to return the text (ward) which is clicked on. I'm sorry if this isn't clear but i'm a bit new to control buttons and macros and stuff.
i'd really appreciate some help
jamie

Audiojoe · Mar 19th, 2002, 08:43 AM

OK, say you want it in Cell A1, you'd need to put put this in your Combobox event:

Worksheets("sheetwhatever").range("a1").value = combobox1

Hope this helps

Dave Hawley · Mar 19th, 2002, 08:43 AM

Hi Jamie

I have an example here that would be helpful. It has the formula you need to return the text from the ComboBox, among other things.

http://www.ozgrid.com/download/default.htm
Down the very bottom is:
ChangingCombo2.zip
Download it.

Juan Pablo González · Mar 19th, 2002, 09:38 PM

If you're using a Form toolbar ComboBox use the Linked cell to get the "row" number of the selection, then use the INDEX function to retrieve the "actual" selected text. Something like

=INDEX(ComboBoxFillRange,LinkedCell)

Mar 19th, 2002, 09:38 PM	#4
Juan Pablo González MrExcel MVP Join Date: Feb 2002 Location: Bogota, Colombia Posts: 11,927	If you're using a Form toolbar ComboBox use the Linked cell to get the "row" number of the selection, then use the INDEX function to retrieve the "actual" selected text. Something like =INDEX(ComboBoxFillRange,LinkedCell) __________________ Regards, Juan Pablo González http://www.juanpg.com

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

Mar 19th, 2002, 08:39 AM	#1
jimmywanna Board Regular Join Date: Mar 2002 Posts: 182	I have made a combobox which lists wards which medication is to be sent to. I need to know how: when the user clicks on one of the 10 ward which drop down from the combo box, this then appears in another cell. So far i can only manage (using the help) to get it to return a number which relates to the position in the drop down list which is clicked. i need it to return the text (ward) which is clicked on. I'm sorry if this isn't clear but i'm a bit new to control buttons and macros and stuff. i'd really appreciate some help jamie

Mar 19th, 2002, 08:43 AM	#2
Audiojoe Board Regular Join Date: Feb 2002 Location: Where the wild roses grow Posts: 285	OK, say you want it in Cell A1, you'd need to put put this in your Combobox event: Worksheets("sheetwhatever").range("a1").value = combobox1 Hope this helps

Mar 19th, 2002, 08:43 AM	#3
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	Hi Jamie I have an example here that would be helpful. It has the formula you need to return the text from the ComboBox, among other things. http://www.ozgrid.com/download/default.htm Down the very bottom is: ChangingCombo2.zip Download it.