I have benefited much from reading the postings on this group
(thanks to all of you!), so from now on, I'll toss my ideas in as
well for whatever they are worth, in hopes to help others as you
have all helped me.
But, at the moment, I haven't been able to find anything on
whether I can highlight specific lines in a userform listbox.
The macro I am working on is for a 911 center, and for the most
part is simply sorting the data into the relevant categories, which
is going fine. On the spreadsheet, the lines which have gone past
certain criteria are highlighted so the user can locate them easily
(e.g. if a call goes past 45 seconds without a dispatch response,
then a supervisor must review the tape of the call). There are 3
types of potential problem lines, which I have identified in
column "A", as "PS", "PT" and "Both" respectfully. I have
arbitarily used a "yellow" background for the "PS" type
errors, "blue" for the "PT" type, and "green" for the "both"
category. On the spreadsheet, that's no problem at all, easily done
in VBA (that is, thanks to the help from all of you).
My question is relevant to the userform I am setting up for a
supervisor to make comments in response to the specific problem--
this being prompted by some of the supervisors being not as computer-
wise as others. Is there a way for me to make the lines which
contain a potential problem line highlighted in a listbox, just as I
have on the spreadsheet? Otherwise, I think I have it set up ok so
far.
Is this possible?