Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Displaying Name Box Contents
Hi, I have named each cell on a worksheet. When a cell is selected, the name
appears in the "Name Box" as usual. Is there a way I can display the name of the selected cell on the spread sheet? I do not want the Name Box or the Formula Bar to be shown on the display to those entering data. Thank you. rope |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Displaying Name Box Contents
Hi, I have named each cell on a worksheet NOT a good idea. -- Don Guillett Microsoft MVP Excel SalesAid Software "Rope" wrote in message ... Hi, I have named each cell on a worksheet. When a cell is selected, the name appears in the "Name Box" as usual. Is there a way I can display the name of the selected cell on the spread sheet? I do not want the Name Box or the Formula Bar to be shown on the display to those entering data. Thank you. rope |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Displaying Name Box Contents
You could use Comments. (Lookup in Help for more info.) However, you need to
hover the cursor over the cell to see the comment or turn on 'Show comments' which tends to hide other info on the worksheet. -- Regards, OssieMac "Rope" wrote: Hi, I have named each cell on a worksheet. When a cell is selected, the name appears in the "Name Box" as usual. Is there a way I can display the name of the selected cell on the spread sheet? I do not want the Name Box or the Formula Bar to be shown on the display to those entering data. Thank you. rope |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Displaying Name Box Contents
As OssieMac mentioned, you could use comments, but the user can turn
them off. I prefer using a Data Validation Input Message (Data ribbon in 07), which will display whenever the cell is selected (even if they browse there with the keyboard). Protection also might work in your case because users can opt to use the Tab key to navigate to only unprotected cells. On Jul 3, 5:00*pm, Rope wrote: Hi, I have named each cell on a worksheet. *When a cell is selected, the name appears in the "Name Box" as usual. *Is there a way I can display the name of the selected cell on the spread sheet? *I do not want the Name Box or the Formula Bar to be shown on the display to those entering data. *Thank you. rope |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Displaying Name Box Contents
You name "each cell on a worksheet"? All 16,777,216 of them?? Really??? If you are hiding the Name Box and Formula Bar (which is what I assume you meant by your next-to-last sentence), then where on the spread sheet did you want to "display the name of the selected cell"? -- Rick (MVP - Excel) "Rope" wrote in message ... Hi, I have named each cell on a worksheet. When a cell is selected, the name appears in the "Name Box" as usual. Is there a way I can display the name of the selected cell on the spread sheet? I do not want the Name Box or the Formula Bar to be shown on the display to those entering data. Thank you. rope |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Displaying Name Box Contents
on the sheet's code page (right click the tab & select View Code) add this: Private Sub Worksheet_SelectionChange(ByVal Target As Range) On Error Resume Next Range("A1") = "" Range("A1") = Target.Name.Name End Sub it gets a range name and places it in cell A1. The error trap is there because there's an error if the cell hasn't got a range name the following code places the name in the status bar: Private Sub Worksheet_SelectionChange(ByVal Target As Range) On Error Resume Next Application.StatusBar = False Application.StatusBar = Target.Name.Name End Sub "Rope" wrote in message ... Hi, I have named each cell on a worksheet. When a cell is selected, the name appears in the "Name Box" as usual. Is there a way I can display the name of the selected cell on the spread sheet? I do not want the Name Box or the Formula Bar to be shown on the display to those entering data. Thank you. rope |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Displaying cell contents | Excel Discussion (Misc queries) | |||
Displaying Cell Contents | Excel Discussion (Misc queries) | |||
Displaying cell contents | Excel Programming | |||
Displaying contents of 2 cells in another | Excel Worksheet Functions | |||
Need help displaying array contents | Excel Programming |