| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Go to from reference in VBA code to actual cell?
When looking at VBA code, is there a quick way (shortcut key) to go to a
cell which is referenced in the code? John Dalberg |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Go to from reference in VBA code to actual cell?
If you are wanting to see the value of the cell, you can use the
Immediate window by pressing Ctrl+G then type "?Range("A1").Formula" (without quotes) and press enter Charles John Dalberg wrote: When looking at VBA code, is there a quick way (shortcut key) to go to a cell which is referenced in the code? John Dalberg |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Go to from reference in VBA code to actual cell?
"Die_Another_Day" wrote:
If you are wanting to see the value of the cell, you can use the Immediate window by pressing Ctrl+G then type "?Range("A1").Formula" (without quotes) and press enter Actually I want it to be more visual and want to see where it resides in the worksheet, doing this will give me the formula and the value. John Dalberg wrote: When looking at VBA code, is there a quick way (shortcut key) to go to a cell which is referenced in the code? John Dalberg |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Go to from reference in VBA code to actual cell?
resize the VBE and give Excel/VBE each half a screen. then you can maneuver
in the Excel side of the screen An alternative would be to build your own COM addin that supports this functionality. -- Regards, Tom Ogilvy "John Dalberg" wrote: When looking at VBA code, is there a quick way (shortcut key) to go to a cell which is referenced in the code? John Dalberg |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Go to from reference in VBA code to actual cell?
?B?VG9tIE9naWx2eQ==?= wrote:
resize the VBE and give Excel/VBE each half a screen. then you can maneuver in the Excel side of the screen The whole idea for my request is so that I don't have to do this and make it as painless as possible. An alternative would be to build your own COM addin that supports this functionality. I am not a COM developer. Is there anything downloadable out there? John Dalberg |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Go to from reference in VBA code to actual cell?
John,
Not sure if it's what you are looking for, but the Locals window (ViewLocal) gives you the info on the current variables/objects NickHK "John Dalberg" ... ?B?VG9tIE9naWx2eQ==?= wrote: resize the VBE and give Excel/VBE each half a screen. then you can maneuver in the Excel side of the screen The whole idea for my request is so that I don't have to do this and make it as painless as possible. An alternative would be to build your own COM addin that supports this functionality. I am not a COM developer. Is there anything downloadable out there? John Dalberg |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Use text from a cell reference in vba code. | Excel Discussion (Misc queries) | |||
| follow up: the actual code | Excel Discussion (Misc queries) | |||
| Can someone help me put psuedo code into actual excel macro?? | Excel Discussion (Misc queries) | |||
| Cell Reference is Worksheet Name in VB Code | Excel Programming | |||
| & reference answering as Date Serial # not actual text | Excel Worksheet Functions | |||
Hybrid Mode
