Hii
I have a some data with limits expiry on different dates. I want to have
popup window to appear whenever the limit is about to expire like 15 to 30
days earlier. Can anyone help me for VBA coding.
Regards
Mahreen
--
---
----Module Sheet1
>
> Private Sub Worksheet_Activate()
> ExpiryWarning
> End Sub
>
> -Tiisworkbook Module
>
> Private Sub Workbook_Open()
> ExpiryWarning
> End Sub
>
>
>
> On Sun, Jun 19, 2011 at 12:25 AM, Mahreen Ellahi
>
sgBox t, 48, "Warning"
> End If
> End If
> End If
>Next
> Cells(1).Activate
> End Sub
> =
>
>
> On Sun, Jul 3, 2011 at 7:16 PM, Mahreen Ellahi
> wrote:
>
>> Hiii
>>
>> Thanks to ST Devi, I hav
Kindly unsubscribe me from the group.
Extreme Regards
Mahreen
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins dow
Guys
I have some serious and need some help.
I have an excel file with these field
Debt : Equity Ratio
*Insert Debt to Equity Ratio: * *3.00* Up to 2 3 Above 2 to 3 1 Above 3
to 4 0 Above 4 -3 Score 1
The score is derived through a formula. The cell shall be protected and no
formula
ou do it Mahreen.
>
> Create a named range using the formula you already have. And in
> validation, use List, and type NA,=NmRnge
>
> where NmRnge is your named range
>
> Check attached.
>
> Sam
>
>
> On Tue, Nov 1, 2011 at 9:53 PM, Mahreen Ellahi
> wrote:
&g
Thanks both of u for the solution :-) I have different cells in my sheet
which are to be added which includes both text and number. I am not able
generate result with these formulas. Once again help needed.
On Wed, Nov 2, 2011 at 12:11 AM, Haseeb Avarakkan <
haseeb.avarak...@gmail.com> wrote:
> H
I ve to add points scored in each table. When the points are NA, total is
not possible. Plz see attached file.
Mahreen
On Thu, Nov 3, 2011 at 4:49 AM, Haseeb Avarakkan wrote:
> Mahreen,
>
> If you have multiple ratio values define a name for them each, like
> Table1, Table2 & choose which table
Don Guillett
> SalesAid Software
> dguille...@gmail.com
>
> *From:* Mahreen Ellahi
> *Sent:* Thursday, November 03, 2011 10:33 AM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Help
>
> I ve to add points scored in each table. When the points are NA, to
Sorry i checked late
Wowww such a simple solution great thanks alot
Mahreen
On Thu, Nov 3, 2011 at 10:23 PM, Sam Mathai Chacko wrote:
> So did you check my post?
>
> Sam
>
>
> On Thu, Nov 3, 2011 at 10:03 PM, Mahreen Ellahi
> wrote:
>
>> I want the user either
Can anybody tell me how to increase font size in drop down menu like when a
user selects the menu, the options are too small and not visible.
regards
Mahreen
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
I ve already gone through this link, thanks. But i dont ve a combo box, i
ve used data validation.
On Thu, Nov 10, 2011 at 3:27 PM, wrote:
> Hi,
> Please refer the link
> http://www.contextures.com/xlDataVal10.html
>
> Regards,
> waheed
> On , Mahreen Ellahi wrote:
> &
Thanks :-(
On Thu, Nov 10, 2011 at 3:43 PM, wrote:
> Hi,
> Its fixed size you cant change it.
> Plz refer the below link
> http://www.contextures.com/xldataval08.html
>
> On , Mahreen Ellahi wrote:
> > I ve already gone through this link, thanks. But i dont ve a com
Any code?
On Thu, Nov 10, 2011 at 3:55 PM, wrote:
> Well u can use the code mentioned in the link to make it zoom a bit
>
> On , Mahreen Ellahi wrote:
> > Thanks :-(
> >
> >
> >
> > On Thu, Nov 10, 2011 at 3:43 PM, waheedb...@gmail.com> wrote:
&
code module.
> Change the column reference from 4 to match your worksheet
>
> On , Mahreen Ellahi wrote:
> > Any code?
> >
> > On Thu, Nov 10, 2011 at 3:55 PM, waheedb...@gmail.com> wrote:
> >
> >
> > Well u can use the code mentioned in the link
Hey thanks Priyanka, it workss perfectly the way I wanted to thanks alot :)
On Fri, Jan 20, 2012 at 12:20 PM, PrIyAnKa wrote:
> Dear Mahreen
>
> Kindly find the attached file and see the yellow highlighted row ,i have
> did the same w/o pivot
>
>
>
> On Thu, Jan 19, 2
Hi All
I have a little query regarding VLOOKUP Formula. I have been using it
depending on only one value. But now I want to use for two dependents. The
attached file has two sheets one with the master data and the other one
where I extract data using VLOOKUP.
*Customer No.* *Proposal No.* *
Hi All
I have a little query regarding VLOOKUP Formula. I have been using it
depending on only one value. But now I want to use for two dependents. The
attached file has two sheets one with the master data and the other one
where I extract data using VLOOKUP.
*Customer No.* *Proposal No.* *
Hey thanks alot all of you guys .. all the sheets serves my purpose but Ajit
I found ur solution more easy to use ... Kamran yous solution is abit
complicated but still thanks for the solution I'll try to understand it
...
Many thanks to all
Regards
Mahreen
On Mon, Nov 17, 2008 at 12:36 AM,
Thanks alot for the link it is very helpful in thorough understanding of the
formula
On Mon, Nov 17, 2008 at 4:04 AM, Bertone, Joseph S. <[EMAIL PROTECTED]>wrote:
>
> Here you go-
> Great step-by-step
> (it takes a moment or two to load...)
>
>
> http://blogs.msdn.com/excel/archive/2008/10/23/cr
Can u tell me anyother freeware which helps convert pdf into word, excel and
jpg files?
On Sat, Dec 27, 2008 at 11:29 AM, Ajit Navre wrote:
> Merry X'mas,
>
>
>
> If you are using Office 2003, or 2007, then MS itself provide for a PDF
> AddIn. You just need to download it from the Microsoft dow
I have few cells in excel worksheet that I want to show as header in print
copy. Can any one tell me how to select those cells to show as print header.
Regards
Mahreen
--~--~-~--~~~---~--~~
--
p"*
> *¨`·.·´¨) Always
> `·.¸(¨`·.·´¨) Keep
> (¨`·.·´¨)¸.·´ Smiling!
> `·.¸.·´
> (¨`·.·´¨) (¨`·.·´¨)
> `·.¸(¨`·.·´¨)¸.·´
> `·.¸.·«*:·.
> .·:*
> *:·.
> *«*:·.
> .·:*
> *:·.
>
> *
> On Thu, Apr 9, 2009 at 12:38 PM, Mahreen Ellahi <
> mahreen.a...@googlemail.com> wrote:
>
>> I have few cells in excel worksheet that I want
23 matches
Mail list logo
