You are welcome Bob :)
Best Regards,
DILIPandey
On 6/3/11, Bob <bobandrich...@comcast.net> wrote:
> Thank you so much for your help!!! That got it!
>
> On Jun 1, 2:14 am, Dilip Pandey <dilipan...@gmail.com> wrote:
>> Hi Bob,
>>
>> I am not sure how many rows you have, hence came up with following:-
>> Sub dkp()
>>
>> For i = 1 To Range("b65536").End(xlUp).Row
>>
>> If IsError(Selection) = True Then
>> Range("b3").Value = InputBox("Enter you value", "Input reqd")
>> End If
>> ActiveCell.Offset(1, 0).Select
>>
>> Next
>> End Sub
>>
>> let me know if it works :)
>>
>> Best Regards,
>> DILIPandey
>>
>> On 6/1/11, Bob <bobandrich...@comcast.net> wrote:
>>
>>
>>
>>
>>
>> > 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 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 -
>
--
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
