Hey whether this will work with all office versions or with version later
than office 2007
On Tue, May 31, 2011 at 11:15 AM, Dilip Pandey <dilipan...@gmail.com> wrote:
> Hi Bob,
>
> After your formula part of the code, insert the following:-
>
> If IsError(Range("b3")) = True Then
> Range("b3").Value = InputBox("Enter you value", "Input reqd")
> End If
>
> Let us know if this helps :)
>
> Best Regards,
> DILIPandey
>
> On 5/31/11, Bob <bobandrich...@comcast.net> wrote:
> > I'd like to enter my own value if there is no match. As the code
> > stands now it will not allow
> > me to enter my own value, returns the #N/A error and each time I try
> > and change this it fires the code again and return the error again. I
> > need something like... If A3 = "#N/A" then Enter "Your Own Value"
> > Thanks in advance!!!
> > 'Worksheets("Worksheet2").Range("B3").Formula =
> > "=if(A3="""","""",index('Customer Record'!B:B,match(A3,'Customer
> > Record'!A:A,0),1))"
> > 'Worksheets("Worksheet2").Range("B3",
> > Range("A65536").End(xlUp).Offset(1, 1)).FillDown
> >
> > --
> >
> ----------------------------------------------------------------------------------
> > Some important links for excel users:
> > 1. Follow us on TWITTER for tips tricks and links :
> > http://twitter.com/exceldailytip
> > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> > 3. Excel tutorials at http://www.excel-macros.blogspot.com
> > 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
> >
> > To post to this group, send email to excel-macros@googlegroups.com
> >
> > <><><><><><><><><><><><><><><><><><><><><><>
> > Like our page on facebook , Just follow below link
> > http://www.facebook.com/discussexcel
> >
>
>
> --
> Thanks & Regards,
>
> DILIP KUMAR PANDEY, mvp
> MBA,B.Com(Hons),BCA
> Mobile: +91 9810929744
> dilipan...@gmail.com
> dilipan...@yahoo.com
> New Delhi - 62, India
>
> --
>
> ----------------------------------------------------------------------------------
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
--
Ajay Kumar Kurup
Branch Manager(MBAC)
LIC Of India
TIRUPUR
9655566820
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
