Running variable updates and VBA codes simultaneously

Asked By 10 points N/A Posted on -

Hi experts

At the same time as the variables update I want to run VBA codes automatically. Also I have VBA codes in 14 pages. Am I able to write all my macros in one VBA model? By using VBA codes how can I auto run my macros?

Please help.

Thank you.


Answered By 0 points N/A #98316

Running variable updates and VBA codes simultaneously


You have to define the macros where they are going to be used and in what states.

  1. If you have the 14 pages all in a same directory server or a folder then it is very easy to access them simultaneously at any time.
  2. Just make a new page with a macro that will access all the VBA codes in the 14 pages.
  3. Define the type of macro and type of pages when making one.
  4. Once done, point the macro to each address of all the 14 pages and save it.
  5. Run and it will automatically do the things. The only thing that you need to take care of is that the macro should not get any null value at any point.

Login/Register to Answer

Related Questions