| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Listbox linked cell does not change
I have a linked cell to an insheet dropdown that loses its connection. The
listbox has "$AK$5" as its linked cell in in its .LinkedCell property. The list of choices is about 35 names. No matter what I select in the listbox, it does not change the linked cell. Anybody else encounter this? What can I do about it? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Listbox linked cell does not change
Try making the link name explicit in the dropdown dialog box ...
"Sheet1!$A$K$5". Frank "Dkline" wrote in message ... I have a linked cell to an insheet dropdown that loses its connection. The listbox has "$AK$5" as its linked cell in in its .LinkedCell property. The list of choices is about 35 names. No matter what I select in the listbox, it does not change the linked cell. Anybody else encounter this? What can I do about it? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Listbox linked cell does not change
Figued it out. The selected item is the one highlighted in blue. If the user
merely scrolls through the list but does not highlight the selection, it "keeps" the old value because it is still selected. "Frank Hayes" wrote: Try making the link name explicit in the dropdown dialog box ... "Sheet1!$A$K$5". Frank "Dkline" wrote in message ... I have a linked cell to an insheet dropdown that loses its connection. The listbox has "$AK$5" as its linked cell in in its .LinkedCell property. The list of choices is about 35 names. No matter what I select in the listbox, it does not change the linked cell. Anybody else encounter this? What can I do about it? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Listbox 2 takes the value of Listbox 1 | Excel Discussion (Misc queries) | |||
| How to force a cell value to change if Linked cell moves? | Excel Discussion (Misc queries) | |||
| listbox B conditional of input in Listbox A | Excel Discussion (Misc queries) | |||
| Listbox NOT in cell | Excel Discussion (Misc queries) | |||
| Change sheet name on linked cell by dropdown box | Excel Worksheet Functions | |||
Linear Mode
