+ Reply to Thread
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?

  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

+ Reply to Thread

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