Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range Reference in Visual Basic
Hi:
I have the following worksheet based macro in VBA: Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$F$5" Then Run "buttonchange" End If End Sub I want to expand the target address to F5 OR F6, and have no idea how to do it. Whatever I try $F$5:$F$6, $F$5 OR $F$6 or a myriad of variations around that come up with a compile error OR don't work! Anyone got any thoughts on this? Regards John Baker |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range Reference in Visual Basic
simplest would be
If Target.Address = "$F$5" or Target.Address = "$F$6" Then or intersect(target,range("f5:f6")) -- Don Guillett SalesAid Software "John Baker" wrote in message ... Hi: I have the following worksheet based macro in VBA: Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$F$5" Then Run "buttonchange" End If End Sub I want to expand the target address to F5 OR F6, and have no idea how to do it. Whatever I try $F$5:$F$6, $F$5 OR $F$6 or a myriad of variations around that come up with a compile error OR don't work! Anyone got any thoughts on this? Regards John Baker |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range Reference in Visual Basic
try
If Target.Address = "$F$5" OR Target.Address = "$F$6" Then Run "buttonchange" End If regards ojv -----Original Message----- Hi: I have the following worksheet based macro in VBA: Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$F$5" Then Run "buttonchange" End If End Sub I want to expand the target address to F5 OR F6, and have no idea how to do it. Whatever I try $F$5:$F$6, $F$5 OR $F$6 or a myriad of variations around that come up with a compile error OR don't work! Anyone got any thoughts on this? Regards John Baker . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range Reference in Visual Basic
John
Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$F$5" Or Target.Address = "$F$6" Then Run "buttonchange" End If End Sub Gord Dibben XL2002 On Sat, 22 Nov 2003 13:18:12 GMT, John Baker wrote: Hi: I have the following worksheet based macro in VBA: Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$F$5" Then Run "buttonchange" End If End Sub I want to expand the target address to F5 OR F6, and have no idea how to do it. Whatever I try $F$5:$F$6, $F$5 OR $F$6 or a myriad of variations around that come up with a compile error OR don't work! Anyone got any thoughts on this? Regards John Baker |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range Reference in Visual Basic
Just to give another option...
Private Sub Worksheet_Change(ByVal Target As Range) Select Case Target.Address(False, False) Case "F5", "F6" Run "buttonchange" End Select End Sub -- Dana DeLouis Using Windows XP & Office XP = = = = = = = = = = = = = = = = = "John Baker" wrote in message ... Hi: I have the following worksheet based macro in VBA: Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$F$5" Then Run "buttonchange" End If End Sub I want to expand the target address to F5 OR F6, and have no idea how to do it. Whatever I try $F$5:$F$6, $F$5 OR $F$6 or a myriad of variations around that come up with a compile error OR don't work! Anyone got any thoughts on this? Regards John Baker |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If Range not equal to zero in Visual Basic If/Then statement | Excel Discussion (Misc queries) | |||
Visual Basic to reference value in Excel cell | Excel Programming | |||
Visual Basic Range variable | Excel Programming | |||
Visual basic to step through range and store a value based on text attribute value. | Excel Programming | |||
Visual basic to step through range and store a value based on text attribute value. | Excel Programming |