Can you name some peaceful or placid items?

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

Was this solution helpful to you?

Related Q & A:

Just Added Q & A:

Find solution

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.