Re: $$Excel-Macros$$ Re: Auto clear content

2015-02-23 Thread Vaibhav Joshi
Hi Try this..put this code in worksheet module for which this to be work, this will delete content of column 3, you can set to desired column: *Private Sub Worksheet_SelectionChange(ByVal Target As Range)Columns(3).ClearContents 'clears content of column 3End Sub* *Cheers!!* *O*n Tue, Feb 24

Re: $$Excel-Macros$$ Re: Auto clear content

2015-02-23 Thread Ahmad Mustfa
kumar i got it what you sent. it's open with alt+f11 not ctrl+f11 now i want this only one specific column not on all sheet. can you please send formula for that On Mon, Feb 23, 2015 at 7:43 PM, Ahmad Mustfa wrote: > i want this in a specific column not on all sheet > > On Mon, Feb 23, 2015 at

Re: $$Excel-Macros$$ Re: Auto clear content

2015-02-23 Thread Ahmad Mustfa
i want this in a specific column not on all sheet On Mon, Feb 23, 2015 at 7:40 PM, Ahmad Mustfa wrote: > Thanks kumar. > how you did that. i am still confused? how i can use in my work? can you > please have online chat with me. > > On Mon, Feb 23, 2015 at 7:22 PM, Suresh Kumar B < > bsureshkuma

Re: $$Excel-Macros$$ Re: Auto clear content

2015-02-23 Thread Ahmad Mustfa
Thanks kumar. how you did that. i am still confused? how i can use in my work? can you please have online chat with me. On Mon, Feb 23, 2015 at 7:22 PM, Suresh Kumar B wrote: > Hi Ahmad, > > Here you go!!! > > By, > Suresh Kumar.B > > On Tuesday, February 24, 2015 at 12:45:22 AM UTC+5:30, Ahmad

Re: $$Excel-Macros$$ Re: Auto clear content

2015-02-23 Thread Suresh Kumar B
Hi Ahmad, Here you go!!! By, Suresh Kumar.B On Tuesday, February 24, 2015 at 12:45:22 AM UTC+5:30, Ahmad Mustfa wrote: > > Thanks Kumar. > Can you please send me in the excel file. i am trying but unable to > understand to how to do that. > > On Mon, Feb 23, 2015 at 6:59 PM, Suresh Kumar B >

Re: $$Excel-Macros$$ Re: Auto clear content

2015-02-23 Thread Ahmad Mustfa
Thanks Kumar. Can you please send me in the excel file. i am trying but unable to understand to how to do that. On Mon, Feb 23, 2015 at 6:59 PM, Suresh Kumar B wrote: > Hi Ahmad, > > Please follow my instructions to clear what do you want, > > Steps: > 1. Goto to Excel page, Press CTRL+F11 > 2.

$$Excel-Macros$$ Re: Auto clear content

2015-02-23 Thread Suresh Kumar B
Hi Ahmad, Please follow my instructions to clear what do you want, Steps: 1. Goto to Excel page, Press CTRL+F11 2. After that, in the left hand side shows the sheets menu, Double click that after paste the following code. *Private Sub Worksheet_SelectionChange(ByVal Target As Range)* *Dim r As