sharing variables between form and module code

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

Guest

I need to coordinate execution between code based in Modules (accessed by
button driven macros) and events within form based code. I've defined
several public variables for this purpose, but the form based code doesn't
seem to be able to see the variables defined as public in the module and vice
versa. I haven't found anything else to use other than maybe using some
cells in the spreadsheet for this purpose. Can someone tell me if there is
something I can use within VBA to do what I want?
 
Hi TimK, That's how I do it. Make a cell on a sheet in the workbook that
holds the code equal to the variable in the control's code. Then you can
assign a variable to that value in the cell and carry on.
 

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

Defining public/global variables in more than one place 1
Declaring Variables 3
Public Variables, Class Modules and Standard Modules 2
Access variable from form and module? 1
Using variables across userforms 3
Passing a variable from sheet code to a module 2
Share global variable between workbooks 2
retaining variable values across modules 3

Back
Top