This does work. But only for range B3. Is there a way to once B3 has
already been entered go to NEXT ROW. Thanks so much for your help!!!
On May 31, 1:45 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 athttp://www.excel-macros.blogspot.com
> > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> > 5. Excel Tips and Tricks athttp://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- Hide quoted text -
>
> - Show quoted text -
--
----------------------------------------------------------------------------------
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
