MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Change Color and/or font on listbox items?

  Asked By: Luke    Date: Dec 26    Category: MS Office    Views: 3073

I am doing a simple Tasks/To-Do list in excel, which basically
records tasks by day and time required, due date etc. Each task is one
When you first open it up, it reads each row on the sheet and displays
it in a listbox (inside a userform).

Is there a way to differentiate between these items on the listbox?
More specifically, I am looking to make the Tasks with past due dates
as RED, or bold, or anything that would make them stand out?

If it cannot be done in a listbox, is there anything else I can use to
display these tasks?
The whole idea is that users do not enter tasks on the sheet itself,
but through the userforms so as to preserve formatting.



2 Answers Found

Answer #1    Answered By: Alyssa Campbell     Answered On: Dec 26

I think you would do better letting them see the worksheet, but protect it,
and put a button to bring up the "New Task" userform.

Answer #2    Answered By: Shelia Wells     Answered On: Dec 26

I do not want them to go to the wsheet for a few reasons,
first the list  is quite long and it would be a waste of time,
one of the things the userform  does is "filter" by user, or by project
etc as each user can see their own tasks.
Also the workbook is going to be shared, and I do not think the
password protection would work (in order to write new tasks, I believe
you have to unprotect it which has issues with shared workbooks).

Any idea  if the listbox  colors can be changed?
If not I guess I have to create a whole separate userform just for
past due dates, although that kinda defeats the purpose.

Didn't find what you were looking for? Find more on Change Color and/or font on listbox items? Or get search suggestion and latest updates.