Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello,
I have a code that works perfect for what I am trying to do, but I don't know how to make it work for more than one field. The Worksheet_Change part works but Worksheet_Change2 doesn't seem to do anything. In the sheet portion of the visual basic I have the following code: Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$L$72" Then If IsEmpty(Target) Then Target = "Intel Celeron at 700MHz - $500" End If End Sub Private Sub Worksheet_Change2(ByVal Target As Range) If Target.Address = "$L$73" Then If IsEmpty(Target) Then Target = "32KB - $100" End If End Sub Why doesn't the second part work? Is this code just in bad form? Thanks for your help! Sean |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
A simple visual basic program | New Users to Excel | |||
Visual Basic Question | Excel Worksheet Functions | |||
Visual Basic Question | Excel Discussion (Misc queries) | |||
Problem with a very simple code in Visual basic | Excel Programming | |||
Need code for Excel Simple Visual Basic Macro to select next avai. | Excel Programming |