Multiple text coloring in same cell using listboxes

Originally Posted by Norie

Mark

It should be possible but I think we'd need more details to suggest specific code.

Perhaps you could attach a sample workbook.

Thanks, so much. If you can help make this work, you are an official genius

Attached is a sample of the full database. Thanks in advance for any help you can provide

Mark

Originally Posted by Norie

Mark

Are multple selections allowed for the first column?

I'd prefer no. But if it has to be that the same Listbox settings are used for each column, then I can live with it being open to multiple. No one would ever use multiple for the colA.

I tried the new code, Norie, but got an error when I clicked on ColB. It now always gives me the same choices regardless of the choice made in ColA? I've tried changing some of the code to make it work, but to no avail? Any help would be appreciated,

Mark

I've attached the updated file with the updated code, so you can see if you get the same results that I do. Thanks again.

Originally Posted by Norie

Right, I know what the problem is with the code, well the code and the data actually.

You've add 1a, 1b etc to the components so there are no matches in the Select Case statement.

Also the Select Case should start like this.

Please Login or Register  to view this content.

Thanks, Nori. That did fix the problem when I changed the data back to the way it was

It's ALMOST there. The conditional formatting that was entered, changes the whole cell to be the same depending on the selections. What I was looking for was like in this example. I need it to happen automatically so the user doesn't have to individually have to go back into the function menu to change the specific string of text. I'd like for Excel to automatically recognize the specific string of text and color it automatically, so you could have two to four different colored texts in one cell.

I hope that makes sense. I've attached an updated sample to explicitly show what I'm talking about.

Again, thanks for all of your help on this. You're awesome!

Mark

Hi Mark
try it (see attachment)

Nilem,

I can't thank you and Nori enough! That is absolutely amazing! You just saved me Weeks and Weeks of Work! You both get the Excel Genius Medal from me Thank you, thank you, thank you!

Mark

Nilem, This is just perfect. Again, I can't thank you enough. There's just one itsy bitsy small little thing which I've tried to accomplish moving around the column references in the VBA code but can't figure out. I'd like to add two columns on the first sheet where the User just enters text. ColA would be Evidence1 and ColB would be Rating1 I can't seem to be able to figure out how to do that.

Also, Under the Rating Column in the first sheet, ColD, I'm using the old DataValidation Method. I cant seem to be able to figure out how turn that into a ComboBox with the same selections.

Once again in advance, deepest thank yous!

Thanks again, Mark

Hi Mark
if I understand correctly your "one itsy bitsy small little thing" (I still have long to learn English ), then see attached file