jimmywanna
Board Regular
- Joined
- Mar 18, 2002
- Messages
- 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
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