Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet_change event multiple
I wanted to test data input on more than one cell. Trying to enter more than
one worksheet_change returns the "ambiguous name" error (same sub name). I realize that I can do all my IF tests and code calls under the one Worksheet_change event but it gets crowded. Is it the only way ? Thanks for any help and education. jeffp |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet_change event multiple
You can only habe one worksheet_change event per worksheet. This is the only
way to do it. what you could do is split up the if..elseif..else...end if from the actual implementation code - something like Private Sub Worksheet_Change(ByVal Target As Range) if target.column = 1 then call DoStuffToColumn1(target) elseif target.column = 2 then call DoStuffToColumn2(target) else ...do whatever end if End Sub private function DoStuffToColumn1(Target as excel.range) ....write code here end function private function DoStuffToColumn2(Target as excel.range) ....write code here end function -- www.alignment-systems.com "jeffP" wrote: I wanted to test data input on more than one cell. Trying to enter more than one worksheet_change returns the "ambiguous name" error (same sub name). I realize that I can do all my IF tests and code calls under the one Worksheet_change event but it gets crowded. Is it the only way ? Thanks for any help and education. jeffp |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
worksheet_change event fires multiple times | Excel Programming | |||
worksheet_change event fires multiple times | Excel Programming | |||
worksheet_change event fires multiple times | Excel Programming | |||
worksheet_change event when multiple cells changed (pasted) | Excel Programming | |||
Worksheet_Change Event | Excel Programming |