+ Reply to Thread
Results 1 to 2 of 2

ListBox cell links

  1. #1
    Registered User
    Join Date
    10-07-2020
    Location
    Brookeville, MD
    MS-Off Ver
    Microsoft Office Professional Plus 2019
    Posts
    1

    ListBox cell links

    I was successful in creating a rudimentary test of ListBox following a variety of online tutorials. From the Properties box of ListBox>Format Control it is straightforward to drag/select "Input range". I seem UNABLE to select a range of "Cell links" in a similar fashion. The "Cell links" box indicates the range, e.g., $B$1:$B$10, but the only cell that works is the first (B1). Indeed, if I select (B2) & click on one of the ListBox options, the effect appears in B1. What?? In Microsoft tutorials the reference is always "cell", singular, not cell range, plural. I tried to "copy down" & it did not work (as I expected).
    Is ListBox (or even ComboBox) fundamentally limited to a single cell? Does it become necessary to recreate the same ListBox for all the cells I need (maybe a couple dozen)?
    Hoping I do not need to resort to VBA. I have no experience there.
    I'm using Microsoft Office Professional Plus 2019.

  2. #2
    Forum Contributor
    Join Date
    08-12-2020
    Location
    Atlanta, Georgia
    MS-Off Ver
    Office 16
    Posts
    241

    Re: ListBox cell links

    List boxes, combo boxes etc. are designed to provide multiple input selections for a single point. The cell link "linkedcell" can only be for a single cell. That is where the "Output" of the selection made in the box goes. If you need more cells to display the output of the box, then put an equals formula in those boxes. I.E. if your cell link is A2, then wherever else you need that to be, put =A2 in that cell.
    If your linked cells require unique solutions that are not tied to the others then you will need to set up a box for each one of those cell points.
    Good luck.

    Squeaky

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Show unique values in listbox and activate related cell if i select value in Listbox
    By HaroonSid in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-22-2018, 06:54 AM
  2. Break links within one cell but not all the links...
    By kgallo in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-23-2016, 12:11 PM
  3. Break some links within a cell, but not all links...
    By kgallo in forum Excel General
    Replies: 2
    Last Post: 08-22-2016, 06:09 PM
  4. [SOLVED] if anything in listbox select first item, if listbox empty do nothing (listbox in userform
    By mcdermott2 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-17-2015, 12:49 PM
  5. how to add url links to listbox using command button
    By biznez1 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-22-2013, 12:26 PM
  6. userform listbox
    By tsiguy96 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 02-14-2013, 11:09 PM
  7. Listbox to Listbox, no duplicates & submitting same UserForm data for each Listbox entry.
    By jamieswift1977 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-18-2012, 12:18 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1