Re: $$Excel-Macros$$ If Condition Problem

2014-09-22 Thread Vaibhav Joshi
Hi Also you may be required to set myAddIn.Installed = True when condition is met,, because once addin is disabled it wont get automatically enabled/installed. CHeers!! + *I did not do this for you. God is here working through me for you.* On Tue, Sep 23, 2014 at 10:06 AM, my excel wrote:

Re: $$Excel-Macros$$ If Condition Problem

2014-09-22 Thread my excel
thanks a lot sir On Mon, Sep 22, 2014 at 3:41 AM, Vaibhav Joshi wrote: > Hi > > Use this code: > > Sub CompName() > > Dim ThisComputerName As String > Dim myAddIn As AddIn > > If UCase(Environ("computername")) = "PCEARTH" Then > ActiveSheet.Range("S1").Value = "INDIA" >

Re: $$Excel-Macros$$ If Condition Problem

2014-09-22 Thread Vaibhav Joshi
Hi Use this code: Sub CompName() Dim ThisComputerName As String Dim myAddIn As AddIn If UCase(Environ("computername")) = "PCEARTH" Then ActiveSheet.Range("S1").Value = "INDIA" Else MsgBox ("Sorry You are Not a Authorised User") ' below sub programs must b

Re: $$Excel-Macros$$ If condition problem

2012-04-21 Thread Maries
*Can you show sample OUTPUT in another column...* * * On Sat, Apr 21, 2012 at 1:16 AM, Ashish Bhalara wrote: > Dear sir, > > I want to write the cell address to fulfill formula, is there any solution > for it? > > Ashish > > > On Sat, Apr 21, 2012 at 12:29 PM, Waseem Saifi wrote: > >> >> I hope th

Re: $$Excel-Macros$$ If condition problem

2012-04-20 Thread Waseem Saifi
I hope this will help You Ashish. On Fri, Apr 20, 2012 at 11:46 PM, Ashish Bhalara wrote: > Dear expert, > > I use date in if formula but not work in attached file, please know me the > my mistake. > > Thanks & regards > > Ashisih Bhalara > > -- > FORUM RULES (986+ members already BANNED for vi

RE: $$Excel-Macros$$ If condition problem

2012-04-20 Thread Rajan_Verma
It working fine in this file, your formula is fully qualified your conditions Rajan. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Ashish Bhalara Sent: Apr/Sat/2012 12:16 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ If condition probl