Excel VBA Example


Excel 2007  Excel 2003  Macros Excel 2007  Macros Excel 2003  Excel 2010 



During
a
classroom session one of the students asked this question: What formula can I use in MS Excel to do the following
Private Sub Worksheet_SelectionChange(ByVal Target As Range) If IsNumeric(Range("C2").Value) Then Range("B2").Value = Range("B2").Value  Range("C2").Value Range("C2").Value = "" End If End Sub Watch the training video below to learn how to solve this problem using Excel VBA: 

Excel 2007  Excel 2003  Macros Excel 2007  Macros Excel 2003  Excel 2010 
