By Uwe Steden on Tuesday, 21 April 2020
Posted in VBA Development
Likes 0
Views 1K
Votes 0
Hello,

I have created a user-form where users can start several macros to finalize a project.
In the user-form, macros that have already been processed are displayed as completed by a check box.
Among other things, standard Aucotec macros are started by the user-form.

For example, if I start the Aucotec macro "create_gaps_in_sheet_numbering", the "selection.item (1)" in the EB tree is changed by the macro.
The user-form can only be started on a project, which was also the first "selection.item (1)".
I need this starting point again in the further course of my user-form macro.

How can I jump back to this point in the EB tree. So the project must be selected again in the EB tree.
At the beginning of my user form macro I saved the starting point (set StartObjProj = Application.Selection.Item (1))

greeting
Uwe
View Full Post