Does Excel see a cell w/ formulas as non-empty cell?

[jwright650]

When using a VBA UserForm to write data to the worksheet....How do you make excel ignore conditional formatting within the cells and see them as blank cells?

I was using the find last row code and when the useform writes the data it sees any conditional formatting as non-blank cells and writes the data in the rows below.

How can I force it to write in the cells with conditional formatting in them?

I will have to post an example tomorrow when I get to work.

[JBeaucaire]

You'd have to post your code. None of the code I use would see a cell with CF on it but nothing in the cell as anything other than empty.

[jwright650]

Please Login or Register  to view this content.

I mis-spoke lastnight about the formatting, I was trying to put in an "If Then" in the cells were it would write true or false, and I was wanting it to say yes or no...If "true", then "yes", "no"......

[JBeaucaire]

Although different in approach, your code worked fine for me once I took out the reference to ListBox1 which apparently doesn't exist.

This is how I would write the same code, small differences.

Please Login or Register  to view this content.

[jwright650]

I took out the reference to ListBox1 which apparently doesn't exist.

JB, I'm going to study your version for a little bit to see what all you did there....(I'm still learning better ways to do things as I go)


The ListBox1 was deleted from that userform and placed on a userform by itself to populate a textbox with the selections(concatenated, if the user chooses more than one cause code)

Yeah, I don't need to set ListBox1 back to null if it doesn't exist...thanks for catching that.

That was one of my first VBA userform projects....I started out with a doosey for my forst project. It was one of those where I would have never got it to work if it wasn't for this forum and the kind folks here who helped me along.

[jwright650]

Used the LastRow method shown above, thread is "Solved"