Refer to control on userform from code module

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a code module that applies to several different controls on a form.

What I want to do is set a reference to the currently displayed form, then
refer to the ActiveControl on that form. How do you do this?

It's easy in Access, but I have not figured out the Excel Object model well
enough to know how to accomplish it in Excel.

Thanks, in advance.
 
You must log in or register to reply here.

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 to change add-in object from within worksheet module. 3
Breaking User Form Code into modules question 9
Userform Control Change from Different Workbook 2
Class Modules and Userforms 3
Call a sub in a modeless userform from a code module? 4
DTPicker controls missing from userform 4
Referencing UserForm event in module 2
Pass Object from UserForm to Code Module 9

Back
Top