Re: $$Excel-Macros$$ Code in the userform for date validation not working properly

A TEXT can never be lesser than a number. At least in the Excel world. Santhosh, please replace the entire code in form1 with this Private Sub CommandButton1_Click() If CDate(TextBox1.Value) > Date Then msg = MsgBox("You cannot make a transaction for a future date", vbCritical, "Your

Re: $$Excel-Macros$$ Code in the userform for date validation not working properly

Dear Santosh, Please see attached sheet i hope it will help to you. -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/* On Mon, Nov 28, 2011 at 3:00 PM, santo

$$Excel-Macros$$ Code in the userform for date validation not working properly

Hi All, In the user form I have coded a date validation which should take data for current date or the previous date only with the help of *calendar only*. However, the code is not working properly. Moreover in the textbox3 I want it to restrict it only for numbers and no character should be all