Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Make a cell in excel an object in VB
Private Sub Worksheet_Change(ByVal Target As Range)
Dim R As Range Set R = Application.Intersect(Target, Range("F9:F15")) If R Is Nothing Then Exit Sub YOUR CODE HERE End Sub EDIT THE RANGE TO SUIT R PETE -- (][ This Email has been scanned by Norton AntiVirus. ][) "CTInt04" wrote in message ... HI, We would like to make a range of cells a single object so that when a change is made only to one of those cells we can run an event procedure. We are currently using the: Private Sub Worksheet_Change function But it runs the event procedure when you click anywhere on the sheet and we only want it to run when a cell in the range is changed. Is making a range of cells an object what we need to do in order to accomplish this if so tell us how, if not do you have any other suggestions. Thank you in advance, CTInt04 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
make camera object refer to dynamic range | Excel Discussion (Misc queries) | |||
Make Object(s) Visible | Excel Discussion (Misc queries) | |||
click on a cell to make an object appear | Excel Worksheet Functions | |||
How can I make an excel cell equal to the value of a frame object text box | Excel Worksheet Functions | |||
IS THERE A WAY TO MAKE AN OBJECT AN EDITABLE PART OF A SPREADSHEET | Excel Programming |