Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I display cell name with Msgbox?
Looks like it's about time to start learn to use the Object Browser, and
the Locals and Immediate windows in the VBA editor. (Most of my VBA books stay on the shelf anymore also.) Since you know that you are probably looking for a property or something that is related to a Range, open up the Object Browser (<F2 key), then type Range into the "Search Text" combo box. You could also choose "Excel" in the "Project/Library" combo box right above it to limit the search. Search Results will show a table with the first column being "Library", the next being Class, and the last being Member. Click on the row that has Excel in the Library column and Range in the Class column. 2 list boxes below the "Search Results" will show Classes and Members of 'Range'. Select "Range" in the Classes list box, then scroll up and down the list of Members in the list box to the right. Notice that "Address" is one of the Members. Click on it and see the arguments, return type, and read/write status in the gray area at the bottom. Alternatively, type in a quick demo routine, like below: Public Sub Test() Dim rng As Range Set rng = ActiveCell End Sub Single-step through the routine, until reaching the End Sub line. In the locals window, open up the "rng" object and see if you can find any properties that look like they might give you what you want. Also, open up the Immediate window, and type in the following (after you type the period, auto-data members should bring up a drop down box so the "Address" can be selected without having to type it all (be sure to include the "?" at the front end): ?rng.Address After pressing Enter, the VBA run-time will return the current result: $A$1 Maybe this is what you are looking for? Try different properties (edit the original line) until you see something interesting, then use Help to get the usage details. Sorry if this reply is sounds condescending, but we all (including me!!!) need to get better at looking up stuff using all of the online resources! I realize Microsoft didn't explain the VBA environment very well or how to use the editor features to the fullest extent. It took me quite a while to learn them also!!! -- Regards, Bill Renaud |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
msgbox to display a cell value, HOW, If possible? | Excel Programming | |||
How to display remaining txt file which overflowed MsgBox display? | Excel Discussion (Misc queries) | |||
display cell value in msgbox formatted as % | Excel Discussion (Misc queries) | |||
MsgBox Display | Excel Programming | |||
Display of $ in Msgbox | Excel Programming |