I need to remove items from a list box in Excel, referencing these items by name- not index location. Can I?
-
I populate a list based on check boxes on a previous page of a dialog box. When someone unchecks a box, i need that part of the list to go away, but I don't want the rest of the entries to be deleted. The list changes all the time, so I can't really reference an index (unless anyone knows some way that I can). Is there any way to delete items by name?
-
Answer:
uhm, if i understand what you mean, you are in VBA? if this is the case, in the code for the checkbox you have your code right now which might look like if checkbox1 = true then Range("A1").formular1c1 = "this text" End if i dono if thats what you have, just an example. so then what you can do is under that add this if Checkbox1 = false then Range("A1").clearcontents end if this way it will put the info in if it is true, and take it out if it is false. this code wasnt tested, dont have excel on this computer. hope it works :)
shawleig... at Yahoo! Answers Visit the source
Related Q & A:
- How do I put an html code in a scroll box?Best solution by html.am
- Do I need to remove wisdom teeth?Best solution by Yahoo! Answers
- I need more friends in my friends list.Best solution by Yahoo! Answers
- I need a catchy name for a business.Best solution by Yahoo! Answers
- I need help coming up with a name for my non-profit organization.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.