How to bold an entire Row on listbox?

General
1

Hi team!

I have a listbox, where i have several data, this table shows values that at the end of each data, is being sum and Shows the Total of this data.

So, when I found the Word “Total”, I wanna bold this data, but doing this I only get to bold only this word:

  Select Case column 
  case 0
    if me.Cell(Row, Column) = "TOTAL"  then
      g.Bold = True
      
    end if
End Select

But that I need to do is to is bold the entire row where the text is placed.
:frowning:

2

replace your code with:

if me.Cell(Row, 0) = "TOTAL" then g.Bold = True end if

3

[quote=289360:@Scott Griffitts]replace your code with:

if me.Cell(Row, 0) = "TOTAL" then g.Bold = True end if[/quote]
perfect!! :smiley: Danke!

4

And I should point out that’s just how to deal with your listbox as it’s already being created. But when adding contents to your listbox you could instead add a rowtag with something like “bold” as the value and then in the celltextpaint event:

if me.rowtag(row) = "bold" then
g.bold = true
end if

That way you don’t have make changes down the line if you decide the word “total” in column 0 is not the bold indicator for the listbox.