subject:"$$Excel\-Macros$$ Clear Contents based on another cell value"

Re: $$Excel-Macros$$ Clear Contents based on another cell value

2011-01-13 Thread Manish

Thanks Ashish
Thanks Dave.
-
Manish

On Jan 13, 7:14 am, Dave Bonallack  wrote:
> Hi Manish,
> Place this code in the appropriate VBA sheet window
>
> Private Sub Worksheet_SelectionChange(ByVal Target As Range)
>     If Target.Column = 2 Then Cells(Target.Row, 3).ClearContents    
> End Sub
>
> Hope this helps
> Regards - Dave.
>
>
>
> > Date: Wed, 12 Jan 2011 02:27:22 -0800
> > Subject: $$Excel-Macros$$ Clear Contents based on another cell value
> > From: pansari.man...@gmail.com
> > To: excel-macros@googlegroups.com
>
> > Hello friends,
>
> > I need a small help.
>
> > I want the VBA code for following task.
>
> > If someone change the value in B2 column, macro will clear the value
> > of C2 column.
> > If someone change the value in column B3, macro will clear the value
> > of column C3 and so on...
>
> > Please suggest me the code.
>
> > Thanks in advance.
>
> > Thnxs,
> > Manish
>
> > --
> > ------
> > 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- 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 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

RE: $$Excel-Macros$$ Clear Contents based on another cell value

2011-01-12 Thread Dave Bonallack


Hi Manish,
Place this code in the appropriate VBA sheet window
 
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Column = 2 Then Cells(Target.Row, 3).ClearContents
End Sub

Hope this helps
Regards - Dave.
 
> Date: Wed, 12 Jan 2011 02:27:22 -0800
> Subject: $$Excel-Macros$$ Clear Contents based on another cell value
> From: pansari.man...@gmail.com
> To: excel-macros@googlegroups.com
> 
> Hello friends,
> 
> I need a small help.
> 
> I want the VBA code for following task.
> 
> If someone change the value in B2 column, macro will clear the value
> of C2 column.
> If someone change the value in column B3, macro will clear the value
> of column C3 and so on...
> 
> Please suggest me the code.
> 
> Thanks in advance.
> 
> Thnxs,
> Manish
> 
> -- 
> --
> 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
  

-- 
--
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

Re: $$Excel-Macros$$ Clear Contents based on another cell value

2011-01-12 Thread ashish koul

Private Sub Worksheet_Change(ByVal Target As Range)

If Target.Column = 2 And UCase(Target.Value) = "YES" Then
Target.Offset(0, 1).Clear
End If

End Sub

if you will type  yes in col b it will clear the content in col c

On Wed, Jan 12, 2011 at 3:57 PM, Manish  wrote:

> Hello friends,
>
> I need a small help.
>
> I want the VBA code for following task.
>
> If someone change the value in B2 column, macro will clear the value
> of C2 column.
> If someone change the value in column B3, macro will clear the value
> of column C3 and so on...
>
> Please suggest me the code.
>
> Thanks in advance.
>
> Thnxs,
> Manish
>
> --
>
> --
> 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
>



-- 
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.com 
*akoul*.wordpress.com 
My Linkedin Profile 


P Before printing, think about the environment.

-- 
--
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


Book1.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ Clear Contents based on another cell value

2011-01-12 Thread Manish

Hello friends,

I need a small help.

I want the VBA code for following task.

If someone change the value in B2 column, macro will clear the value
of C2 column.
If someone change the value in column B3, macro will clear the value
of column C3 and so on...

Please suggest me the code.

Thanks in advance.

Thnxs,
Manish

-- 
--
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

Re: $$Excel-Macros$$ Clear Contents based on another cell value

RE: $$Excel-Macros$$ Clear Contents based on another cell value

Re: $$Excel-Macros$$ Clear Contents based on another cell value

$$Excel-Macros$$ Clear Contents based on another cell value

4 matches

Site Navigation

Mail list logo

Footer information