Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing color of text added to a cell via a form
Good morning,
I've got a workbook with a form whereby different users add a note to a given project. On the form, the user identifies themself as a 'Coordinator' or a 'Developer'. Both types of user can add a note to a project. I've got it programmed so that each note ends with the users initials (entered via the form) as well as the date and time and finally a ~ between each note. All of that works well and as many notes as I want can be added to a cell. However, I would like to be able to change the color of the text, depending on what type of user enters the note (e.g., red for coordinators and blue for developers). When I added that code and tried it the first time, it worked and it turned just the note I entered the appropriate color. But when I would enter subsequent notes, it would turn the text in the entire cell the color of the given user. I want to be able to see "red ~ blue ~ red ~ blue, etc." How can I do this? Thanks for any help. Frank |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing color of text added to a cell via a form
Are the notes saved in cells in the file? Is each note in a separate cell?
What kind of control are you displaying the notes in? Memo field of a form? I'm not sure I can help with this, but answering these questions would allow me to try out what you're doing and maybe find a solution. Keith "Phrank" wrote: Good morning, I've got a workbook with a form whereby different users add a note to a given project. On the form, the user identifies themself as a 'Coordinator' or a 'Developer'. Both types of user can add a note to a project. I've got it programmed so that each note ends with the users initials (entered via the form) as well as the date and time and finally a ~ between each note. All of that works well and as many notes as I want can be added to a cell. However, I would like to be able to change the color of the text, depending on what type of user enters the note (e.g., red for coordinators and blue for developers). When I added that code and tried it the first time, it worked and it turned just the note I entered the appropriate color. But when I would enter subsequent notes, it would turn the text in the entire cell the color of the given user. I want to be able to see "red ~ blue ~ red ~ blue, etc." How can I do this? Thanks for any help. Frank |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing a color in a cell based on the text in another cell | Excel Discussion (Misc queries) | |||
Changing cell text color based on cell number | Excel Programming | |||
Changing cell text color based on cell number | Excel Programming | |||
Changing cell text color based on cell number | Excel Programming | |||
Cell colors or text color changing when date in cell gets closer. | Excel Worksheet Functions |