How do I make it so when you select a certian option from a ListBox, text appears somewhere else? Excel 2003?
-
I have a short(ish) list of numbers in a listbox; how to i make it so that when you click on a number in the box, text appears somewhere else?
-
Answer:
You have to have a formula in the cell that you want to have the text appear in the references the value chosen from the listbox. Right click in the listbox and in the Format Control, Control tab, for the Listbox, you select a cell to link to and that is where the choice will be put. If the choices were numbers from 1 or 2 then this kind of formula would work. I will use A2 for where the linked cell for the listbox is. =IF(A2=1,"YOU HAVE CHOSEN 1",IF(A2=2,"YOU HAVE CHOSEN 2")) etc.
Chris at Yahoo! Answers Visit the source
Related Q & A:
- How do I throw an exception when I receive a signal?Best solution by stackoverflow.com
- How do i make a my yahoo but not a home page?Best solution by Yahoo! Answers
- How do I make a CV to apply for a job?Best solution by wikihow.com
- How can I make JAXB-generated classes participate in a visitor pattern?Best solution by Stack Overflow
- How do I transfer ALL of my songs onto a different iTunes on a different computer?Best solution by Yahoo! Answers
Just Added Q & A:
- How many active mobile subscribers are there in China?Best solution by Quora
- How to find the right vacation?Best solution by bookit.com
- How To Make Your Own Primer?Best solution by thekrazycouponlady.com
- How do you get the domain & range?Best solution by ChaCha
- How do you open pop up blockers?Best solution by Yahoo! Answers
For every problem there is a solution! Proved by Solucija.
-
Got an issue and looking for advice?
-
Ask Solucija to search every corner of the Web for help.
-
Get workable solutions and helpful tips in a moment.
Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.