Listbox linked cell does not change

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Try making the link name explicit in the dropdown dialog box ...
"Sheet1!$A$K$5".

Frank
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Automatically naming and linking controls 6
Repost of listbox losing linked cell 11
change control listbox results to numbers 7
Values in multiselect listbox 2
Wrapping entries in a ListBox 1
Can I keep linked cells between sheets when using tables? 2
Listbox ? 1
ListBox RowSource Property 2

Back
Top