General Ledger
Active Member
- Joined
- Dec 31, 2007
- Messages
- 460
Dear All,
Can I create a Task Pane for an Excel 2003 worksheet? This would look similar to the Help pane that opens when you access Help.
I have a Form where the user selects or enters a Vendor Name. I don't want to use a drop down list because the list of names is long and not all inclusive. I would like a Task Pane on the right side that is visible as long as the Form sheet is active. The Task Pane would have its own scroll bars and would not scroll out of view when the Form is scrolled up and down. This Task Pane would show all the Vendor Names in the list. The source of the Vendor Names will be a named range on another sheet in the same workbook and the list will grow over time. If the user clicks on a name in the Task Pane, it is populated to the Vendor Name field on the Form. If the user selects a different sheet, the Task Pane should close, but reappear when the user makes the Form sheet active.
If I have not reached the outer limits of Excel, let's keep going. I have more lists. Can the Task Pane have tabs across the top where each tab contains a list for different fields. For example, one tab would be Vendor Names and another would be City Names. The user could select a tab to reveal the list, click on an element in the list, and have it populate the corresponding field on the Form.
Am I asking for too much?
Thanks,
GL
Can I create a Task Pane for an Excel 2003 worksheet? This would look similar to the Help pane that opens when you access Help.
I have a Form where the user selects or enters a Vendor Name. I don't want to use a drop down list because the list of names is long and not all inclusive. I would like a Task Pane on the right side that is visible as long as the Form sheet is active. The Task Pane would have its own scroll bars and would not scroll out of view when the Form is scrolled up and down. This Task Pane would show all the Vendor Names in the list. The source of the Vendor Names will be a named range on another sheet in the same workbook and the list will grow over time. If the user clicks on a name in the Task Pane, it is populated to the Vendor Name field on the Form. If the user selects a different sheet, the Task Pane should close, but reappear when the user makes the Form sheet active.
If I have not reached the outer limits of Excel, let's keep going. I have more lists. Can the Task Pane have tabs across the top where each tab contains a list for different fields. For example, one tab would be Vendor Names and another would be City Names. The user could select a tab to reveal the list, click on an element in the list, and have it populate the corresponding field on the Form.
Am I asking for too much?
Thanks,
GL