Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I've reposted this item as I answered the first post on this subject
myself and think therefore it may have got lost in background clutter. I have created a class module that displays a treeview within a userform. The treeview can display several data types. For example, the user gets presented with a tree of service providers which are indexed uniquely by name and country. If the user chooses to add a new service provider, then he will be presented with a second userform ( a second instance of the same userform) that contains a treeview of the countries they may choose from. Each instance of the treeview userform creates a commandbar popup that has awareness of the treeview content, for example, in the first instance to select, add, rename or delete the service provider name, and in the second instance to select, add, rename, delete a country. From what I've understood from this forum and other sources, the CommandBar Popup OnAction target can only reside in a general module. So, my original problem still exists - how can I set things up so that the general OnAction module knows which instance of the treeview userform to act upon? One idea, I guess, is to stack the objects that contain the userform treeviews in a collection and key them on the userform caption - I guess this is what Windows itself does? If I could pass the OnAction module a parameter of the parent treeview userform then it would be much easier. Anyone have any ideas? Many thanks......Neil |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
VBA to sidestep popups... | Excel Worksheet Functions | |||
Using Popups to supply variables | Excel Worksheet Functions | |||
Automated Popups | Excel Worksheet Functions | |||
Using popups instead of Message Box | Excel Programming | |||
Date PopUps | Excel Programming |