Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Visual Basic:Change on event
I wish to reset the properties of several worksheet controls on the
entry into a cell. The visual basic help suggests using Sub Worksheet_Change(ByVal Target as Range) End Sub What is the syntax to be used here is it Sub Worksheet_Change(ByVal .Range("C11"))? or Sub Worksheet_Change(ByVal .Range("C11") as Range)? Sub Worksheet_Change(ByVal ("C11") as Range)? I am using Excel 2004 on OSX 10.4 Thanks Brujolito |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Visual Basic:Change on event
put in the SHEET module
private Sub Worksheet_Change(ByVal Target as Range) if target.address="$A$11" then do your thing end if End Sub -- Don Guillett SalesAid Software wrote in message ups.com... I wish to reset the properties of several worksheet controls on the entry into a cell. The visual basic help suggests using Sub Worksheet_Change(ByVal Target as Range) End Sub What is the syntax to be used here is it Sub Worksheet_Change(ByVal .Range("C11"))? or Sub Worksheet_Change(ByVal .Range("C11") as Range)? Sub Worksheet_Change(ByVal ("C11") as Range)? I am using Excel 2004 on OSX 10.4 Thanks Brujolito |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
MenuBar & Event problems | Excel Discussion (Misc queries) | |||
Disable SelectionChange Event | Excel Discussion (Misc queries) | |||
Unable to Start Excel Event ID 2001 | Excel Discussion (Misc queries) | |||
changing the visual basic in office 2003 to visual studio net | Excel Discussion (Misc queries) | |||
Worksheet Row Change event | Excel Discussion (Misc queries) |