Passing Variable to Macro

**Mota** · 06-09-2010, 02:46 PM

Hi fellows

I'm trying to use the same varaible results in another sub() as described below.

The macro count a value from a huge report.:

Total = Total + (Cells(Rw, colPQty) * Cells(Rw, colRPrice).Value)

Then, I need to use this Total by another Sub ()

How to do that??

Thanks

**davegugg** · 06-09-2010, 03:02 PM

You can either
1) Make the Total an argument in the other sub:

Please Login or Register  to view this content.

2) Use a global variable:

Please Login or Register  to view this content.

For #2, you declare the variable outside of all procedures, usually at the top of the module.

Hope that helps

**Leith Ross** · 06-09-2010, 03:04 PM

Hello Dave,

It looks like the total is a currency value equal to quantity times the price.

**davegugg** · 06-09-2010, 03:06 PM

Understood Leith. Rather than Long, you'd want to dim the variable as a double.

**Mota** · 06-09-2010, 04:32 PM

Hey people,

First of all I would like to thank you for your prompt help.:
I'm starting use VBA and I unsuccessfull on this issue.
It seems to be so easy and I don't know where I'm failing.
See the message error when I tried to run the macro.

Compile Error :
Sub ior Function no defined

Basically this is the part of two sub I'm triyng to fix.

Please Login or Register  to view this content.

---------------

Please Login or Register  to view this content.

Thanks once again

**davegugg** · 06-09-2010, 04:54 PM

I think if you are calling a sub that is run from a button click, you have to use:

Please Login or Register  to view this content.

Props to Andy Pope for teaching me this fact just the other day!

**Mota** · 06-09-2010, 06:34 PM

I tried this but still not working. The macro didn't capture anything.

If frmBOM.OptBOMYes = True Then
ws.Cells(10, "M").Value = BomCost.Value
End If

thank you