Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
cell naming not showing up in drop down list of formula bar
I have a macro that allows you to select a two columnn
range and then uses the left cells text to name the right cell with the following command mcell.Name = mystring Is there a programmatic way to update the list excel uses in the address cell of the formula bar. I have a rather large file that now when this is run the cell is named, but the name only shows up using the f3 command. If you use the cell in a calculation, it just gives the cell reference. If you click on the named cell, it doesn't show up in the address cell of the Excel formula bar. If I manually name a cell by clicking the cell and then typing in the address cell of the formula bar, the named cell works as it should, inserting the name whenever it is used in a formula. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
cell naming not showing up in drop down list of formula bar
This functionality is builtin to Excel - select your 2-column list, then use
Insert/name/Create, and click the "left column" checkbox. I suspect there's a bug in your macro. "mel" wrote in message ... I have a macro that allows you to select a two columnn range and then uses the left cells text to name the right cell with the following command mcell.Name = mystring Is there a programmatic way to update the list excel uses in the address cell of the formula bar. I have a rather large file that now when this is run the cell is named, but the name only shows up using the f3 command. If you use the cell in a calculation, it just gives the cell reference. If you click on the named cell, it doesn't show up in the address cell of the Excel formula bar. If I manually name a cell by clicking the cell and then typing in the address cell of the formula bar, the named cell works as it should, inserting the name whenever it is used in a formula. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Drop down list not showing all the data.... | Excel Discussion (Misc queries) | |||
Data Validation List (Drop Down) Not Showing | Excel Discussion (Misc queries) | |||
Drop down list showing different value | Excel Discussion (Misc queries) | |||
drop down list showing dates instead of numbers | Excel Discussion (Misc queries) | |||
drop down list is not showing | Excel Discussion (Misc queries) |