How to acces data in a hidden form

H

Hans

As it is not possible to use userforms in a modeless state in VBA in
Word 2011 for the Mac, and I still need a userform every now and then,
I hide that userform when I have no need of it and I un-hide (show) it
when I have need of it. I want a macro that can access the information
in the userform, while it is hidden. The information is in a Public
Sub. How can I do that? What lines of code do I need?
I could access some variables by using FormX.VariableY but I want also
to read parts of arrays. That doesn't seem to work in that way.
Thanks in advance,
Hans
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I set focus (and select text) on a text box on a modeless userform? 0
Hide userform - disable Enter key 0
Creating a Chart on form from selected data in query. 0
Drop down list control value in vba 2
Outlook meeting location auto prompts with a suggestion list - need to disable 0
LISTNUM + Mail Merge + INCLUDETEXT : Referencing Paragraph # Can't get to work 0
Word Template where user inputs <TITLE> and then that can be displayed in footers or headers [MAC] 0
Adding data to MS Access from csv file 0

Top