| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
On Cell change call
I am trying to call a sub whenever a single cell of a worksheet is changed.
I know how to do that whenever ANY cell on a worksheet is changed, but is there a way to only call the sub when a SPECIFIC cell is changed. For example, is cell 'b10" (labeled CRN) is changed, I want to call a sub, on the same worksheet, called "FindCRN". Can anyone give me any suggestions? TIA, Ken |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
On Cell change call
Try something similar to this in a Worksheet Change event:
Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$B$10" Then FindCRN End Sub -- Damon Longworth Don't miss out on the 2005 Excel User Conference Sept 16th and 17th Stockyards Hotel - Ft. Worth, Texas www.ExcelUserConference.com "Ken Loomis" wrote in message ... I am trying to call a sub whenever a single cell of a worksheet is changed. I know how to do that whenever ANY cell on a worksheet is changed, but is there a way to only call the sub when a SPECIFIC cell is changed. For example, is cell 'b10" (labeled CRN) is changed, I want to call a sub, on the same worksheet, called "FindCRN". Can anyone give me any suggestions? TIA, Ken |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
On Cell change call
Thanks, Damon. That works well.
I am still laying out the user input worksheet, so I was hoping I could change this: If Target.Address = "$B$10" Then FindCRN to If Target.Address = "CRN" Then FindCRN since 'CRN' is the label for that cell. I tried that but it doesn't work. Is there a way to change that statement to test to see if the call labeled "CRN" has been changed? Or, will I just need to update the "$B$10" whenever I add rows or columns to the finished spreadsheet.? Ken "Damon Longworth" wrote in message ... Try something similar to this in a Worksheet Change event: Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$B$10" Then FindCRN End Sub -- Damon Longworth Don't miss out on the 2005 Excel User Conference Sept 16th and 17th Stockyards Hotel - Ft. Worth, Texas www.ExcelUserConference.com "Ken Loomis" wrote in message ... I am trying to call a sub whenever a single cell of a worksheet is changed. I know how to do that whenever ANY cell on a worksheet is changed, but is there a way to only call the sub when a SPECIFIC cell is changed. For example, is cell 'b10" (labeled CRN) is changed, I want to call a sub, on the same worksheet, called "FindCRN". Can anyone give me any suggestions? TIA, Ken |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
On Cell change call
If Not Intersect(Target, Range("CRN")) Is Nothing Then FindCRN
-- HTH RP (remove nothere from the email address if mailing direct) "Ken Loomis" wrote in message ... Thanks, Damon. That works well. I am still laying out the user input worksheet, so I was hoping I could change this: If Target.Address = "$B$10" Then FindCRN to If Target.Address = "CRN" Then FindCRN since 'CRN' is the label for that cell. I tried that but it doesn't work. Is there a way to change that statement to test to see if the call labeled "CRN" has been changed? Or, will I just need to update the "$B$10" whenever I add rows or columns to the finished spreadsheet.? Ken "Damon Longworth" wrote in message ... Try something similar to this in a Worksheet Change event: Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$B$10" Then FindCRN End Sub -- Damon Longworth Don't miss out on the 2005 Excel User Conference Sept 16th and 17th Stockyards Hotel - Ft. Worth, Texas www.ExcelUserConference.com "Ken Loomis" wrote in message ... I am trying to call a sub whenever a single cell of a worksheet is changed. I know how to do that whenever ANY cell on a worksheet is changed, but is there a way to only call the sub when a SPECIFIC cell is changed. For example, is cell 'b10" (labeled CRN) is changed, I want to call a sub, on the same worksheet, called "FindCRN". Can anyone give me any suggestions? TIA, Ken |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
On Cell change call
Thanks, Bob.
That worked great. Ken "Bob Phillips" wrote in message ... If Not Intersect(Target, Range("CRN")) Is Nothing Then FindCRN -- HTH RP (remove nothere from the email address if mailing direct) "Ken Loomis" wrote in message ... Thanks, Damon. That works well. I am still laying out the user input worksheet, so I was hoping I could change this: If Target.Address = "$B$10" Then FindCRN to If Target.Address = "CRN" Then FindCRN since 'CRN' is the label for that cell. I tried that but it doesn't work. Is there a way to change that statement to test to see if the call labeled "CRN" has been changed? Or, will I just need to update the "$B$10" whenever I add rows or columns to the finished spreadsheet.? Ken "Damon Longworth" wrote in message ... Try something similar to this in a Worksheet Change event: Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$B$10" Then FindCRN End Sub -- Damon Longworth Don't miss out on the 2005 Excel User Conference Sept 16th and 17th Stockyards Hotel - Ft. Worth, Texas www.ExcelUserConference.com "Ken Loomis" wrote in message ... I am trying to call a sub whenever a single cell of a worksheet is changed. I know how to do that whenever ANY cell on a worksheet is changed, but is there a way to only call the sub when a SPECIFIC cell is changed. For example, is cell 'b10" (labeled CRN) is changed, I want to call a sub, on the same worksheet, called "FindCRN". Can anyone give me any suggestions? TIA, Ken |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
On Cell change call
Hi Ken,
One way: Private Sub Worksheet_Change(ByVal Target As Range) On Error GoTo XIT If Not Intersect(Target, Me.Range("CRN")) _ Is Nothing Then Call FindCRN End If On Error GoTo 0 XIT: End Sub --- Regards, Norman "Ken Loomis" wrote in message ... Thanks, Damon. That works well. I am still laying out the user input worksheet, so I was hoping I could change this: If Target.Address = "$B$10" Then FindCRN to If Target.Address = "CRN" Then FindCRN since 'CRN' is the label for that cell. I tried that but it doesn't work. Is there a way to change that statement to test to see if the call labeled "CRN" has been changed? Or, will I just need to update the "$B$10" whenever I add rows or columns to the finished spreadsheet.? Ken "Damon Longworth" wrote in message ... Try something similar to this in a Worksheet Change event: Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$B$10" Then FindCRN End Sub -- Damon Longworth Don't miss out on the 2005 Excel User Conference Sept 16th and 17th Stockyards Hotel - Ft. Worth, Texas www.ExcelUserConference.com "Ken Loomis" wrote in message ... I am trying to call a sub whenever a single cell of a worksheet is changed. I know how to do that whenever ANY cell on a worksheet is changed, but is there a way to only call the sub when a SPECIFIC cell is changed. For example, is cell 'b10" (labeled CRN) is changed, I want to call a sub, on the same worksheet, called "FindCRN". Can anyone give me any suggestions? TIA, Ken |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to call a cell ? | Excel Discussion (Misc queries) | |||
| Call Center Management: How to calculate 'cost per call' | Excel Discussion (Misc queries) | |||
| How do I change a column label to call it what I want ? | New Users to Excel | |||
| How do I change a macro to call a sheet from another workbook | Excel Programming | |||
| How do I change a macro to call a sheet from another workbook | Excel Programming | |||
Hybrid Mode
