LinkBack URL
About LinkBacks
Hi All,
I want to create a pop up message showing count of cells turned red,each time the workbooked are opened.like column "I" has two dates in red colour,so the pop up will say
"you have 2 contracts expired"
Hi All,
I want to create a pop up message showing count of cells turned red,each time the workbooked are opened.like column "I" has two dates in red colour,so the pop up will say
"you have 2 contracts expired"
Last edited by arnab0711; 02-23-2010 at 12:48 PM.
Given the "red cells" simply equate to count of Today I would suggest you run a COUNTIF (of Date / Today() pending which route you take) via the Open Event against whichever ranges are of interest.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
I am not able to do that,can you help me please
Well it's not clear if you need to test multiple ranges or just Column I on KolWB sheet but in the most basic of terms:
the above would reside in ThisWorkbook object in VBEditor.
Please Login or Register to view this content.
Thanks for the reply,but the only thing I want is on file open,the comment should be shown,and the comment will be "the # of contracts expired are contract #"
hello,
I think What DO has suggested may be the simplest solution and doesnot over complacate things.
You could try either of these. You can only have one Private Sub Workbook_Open() in the workbook at a time.
Take a look and try the suggested highlighting and simgle msgboxPlease Login or Register to view this content.
hope this helps
cheers
Hi,I am getting this error "Invalid or unqualified reference" on first formula
and nothing is happening in the second formula
The first code should just be:
Please Login or Register to view this content.
Thanks,its working now
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks