RE: $$Excel-Macros$$ Need Help With an Imput Box in VBA

Try this Sub INputDate() Range("A1").Value = Application.InputBox("Please Enter YOur date", , , , , , , 1) Range("A1").NumberFormat = "mm/dd/yy" End Sub -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Erick C Sent: Friday, August 1

Re: $$Excel-Macros$$ Need Help With an Imput Box in VBA

Hi Erick, Look attached..see if helps... *Best Regards,* *Venkat * *Chennai* * * On Fri, Aug 12, 2011 at 12:34 AM, Erick C wrote: > Hi everybody - > > I am hoping someone can help me out. I have a spreadsheet that I am > currently making a macro in VBA. I would like to have an imput box

Re: $$Excel-Macros$$ Need Help With an Imput Box in VBA

Hi Erick, Please see attached sheet... -- Thanks & regards, Noorain Ansari *http://noorain-ansari.blogspot.com/* On Fri, Aug 12, 2011 at 12:34 AM, Erick C wrote: > Hi everybody - > > I am hoping someone can help me out. I have a spreadshe