| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
forgotten object
Private Sub Worksheet_Change(ByVal Datarget As Range)
Datarget.Font.ColorIndex = 5 End Sub ===================== Hi At one time, I must have gotten this code in the VBAProject | Microsoft Excel Objects | This Workbook. I'm trying to figure where I can find Datarget. Please advise. Thanks Steve |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
forgotten object
Steve,
This line of code might work and tell you the sheet that the range is on. msgbox Datarget.parent.name hth, Doug "SP" wrote in message ... Private Sub Worksheet_Change(ByVal Datarget As Range) Datarget.Font.ColorIndex = 5 End Sub ===================== Hi At one time, I must have gotten this code in the VBAProject | Microsoft Excel Objects | This Workbook. I'm trying to figure where I can find Datarget. Please advise. Thanks Steve |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| forgotten password | Excel Discussion (Misc queries) | |||
| forgotten passwor | Excel Discussion (Misc queries) | |||
| HELP, I'VE FORGOTTEN | Excel Worksheet Functions | |||
| Please help, forgotten password | Excel Discussion (Misc queries) | |||
| Forgotten Password | Excel Programming | |||
![SP[_6_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
