Hello All,
I have a datasheet file in Excel. Now I have to edit it and my boss ask me to change the color red which data or cell is edited. I apply track change but it cannot change the color of text. Please suggest. Your suggestions is highly appreciated. Thanks
The sample file is also attached.
Last edited by indra; 07-28-2010 at 12:39 AM.
right click sheet tab and click viewcode and in the resulting window copy this event code
when you change any cell in the original data and hit enter you will get the red color. Try
Please Login or Register to view this content.
Yes, That's it. It works very perfect to me. You are greate! Thanks for your kind suggestion.
Last edited by indra; 07-28-2010 at 12:34 AM.
I have another Private Sub running above this which colours text red. I am hoping to find a way to allow a user to insert a row whereby instructions pop up in red text. When they key in data as per the instructions, I'd like the text to change back to black. Any thoughts?
Is this on the same page?
What i want to do is to create a payslip generator where I can input the employee's name, designation, rate, number of absences, late/s, and calculate their net pay and generate payslip, all by just using vba codes.
Have you thought about using a Userform to enter the data?
Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.
If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.
Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.
Remember what the dormouse said
Feed your head
Private Sub Worksheet_Change(ByVal Target As Range)
Target.Font.ColorIndex = 3
End Sub
above is good but how we can change the Back ground color of text box?
Dave, welcome to the forum
Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.
If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.
Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Start your own thread and try to attach sample worksheet.
Because that will help to new comers in vba
I'm excited to try this because I really need it to work for something... but when I right-click the sheet tab, and click viewcode the window that pops up doesn't seem to have a place I can copy the code. I'm pretty unsophisticated when it comes to excel, but know enough to get myself in troubleI'm using Office 2013. Not sure if that makes a difference. Any help would be appreciated. (Hopefully) attached is the screenshot of the "viewcode" screen I get.Excel Viewcode.JPG
Click Insert Module
(you should really start your own thread, but we will let this 1 slide)
Venkat,
It's really cool but undo does not work after a data has been changed. Can you slightly modify the code.
parijat_2 welcome to the forum
Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.
If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.
Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.
(also, you generally cannot undo changes made by VBA code)
This is just what I needed also. Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks