Results 1 to 1 of 1

Forms in Excel - How do I link a cell to show me what was selected on an input form?

Threaded View

  1. #1
    Registered User
    Join Date
    04-20-2012
    Location
    Tucson
    MS-Off Ver
    Excel 2010
    Posts
    10

    Forms in Excel - How do I link a cell to show me what was selected on an input form?

    I have created an input form that would be used by our leadership team to request a report to be run. What I was trying to do is add list boxes where the user could scroll down through their choices, and select 1 or many from the list. I was hoping that the items that they selected could be shown on page 2 of the form so that we could use that as our source document to know how to build the report. I would prefer it give me the detail from the list, not just the position # that it is in the list.

    When I originally started building the form, I added the list boxes just as form controls, (not ActiveX controls) - you will see that version on the tab labeled DataRequestForm. When I realized that I couldn't get the cell link to work as I had hoped, I copied that tab to the DataRequestForm-ActiveX tab and started converting the boxes to the ActiveX controls. Once I saw that it still isn't giving me what I had hoped, I stopped converting them over and decided to see if you could help. What I would like to see in Cells E73-E80 is the detail behind what is selected. For example, if they selected financial class B-Blue Cross, and F-HMO, I would like to see both of those items listed in cell E74.

    Any help would be greatly appreciated!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

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