Pointers to creating new Excel Windows Task Panes via VBA automation
Posted on 2013-05-30
I am considering using customised task panes in place of UserForms, in an Excel project.
I've heard that windows task panes can be customised from scratch and can provide comparable dynamic properties to vba userForms, and that so?
I have several dynamic userForms, which are best used modeless. Within the workbook, some are used, individually, in conjunction with more than one worksheet
REASONS for me considering Task Panes - or are they non-reasons??? ========>
-- It would be helpful to enable the modeless dynamic forms could be 'docked' to the main excel window, so the User does not 'lose' them, behind the main window.
-- I'm under the impression that task panes give a more 'professional' appearance to a project.
-- I have other Userforms to create, so a migration to task panes (if a good idea) would be timely.
-- I've read somewhere that it is possible to convert UserForm code to Task Pane code. In practice is this a genuine benefit? ===================================|
Can you give me pointers to set me gathering materials?
What are the main issues for me at this 'thinking' stage?