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!
Bookmarks