• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Vba req

Nabeel

Member
hello all
can any one put vba .i want when i hit the clear button dated cell E7 automatically select then i hit enter again cell H11 selected thenH12 & H13..respeatively I11,I12,I13...... till k13.
regrds
 

Attachments

  • Help.xlsm
    15.1 KB · Views: 0
thnx a lot master..but if req some changes plz can u guide me where i have to change and if i want to add some more cells how can i add it
 
Select the cell > Press Ctrl+1 > Goto Protection Tab > Uncheck Locked

Now go to Protect Sheet > Check Only "Select unlocked cells" > Put the password or leave the blank > Press Ok
 
one more question...i want to write date without dashes & slashes..want to result like 12 Dec 2014..but there is no such format is working..from this format 00\/00\/00 result shown as 12/12/2014 but i want 12 dec 2014.there is any kind of formation is there..thnx
 
one more question...i want to write date without dashes & slashes..want to result like 12 Dec 2014..but there is no such format is working..from this format 00\/00\/00 result shown as 12/12/2014 but i want 12 dec 2014.there is any kind of formation is there..thnx

Is this custom formar : dd mmm yyyy

upload_2015-5-6_0-52-57.png
 
not working ....req format is only showing but result is not accurate..with this format if i put 121215 it is showing
15 Nov 2231
instead of 12 Dec 2015
 
I doesn't think that any VBA is req as once you type 121215 excel will auto convert it to 12-12-15.
 
Back
Top