how to pass parameter to different sub?

[ccs_1981]

can some1 pls help me? i m beginner in writing some marco.
below r my code

Please Login or Register  to view this content.

how to pass the x=10 to sub part1?

[jasoncw]

Are both of those procedures in the same Worksheet module, or is the second in a general module?

If they are both in the same module, you would need to declare the variable at the top of the module, outside the other procedures.

Please Login or Register  to view this content.

If they are in different modules, you will need to declare it as a public variable at the top of a general module.

Worksheet module:

Please Login or Register  to view this content.

General module:

Please Login or Register  to view this content.

HTH

Jason

[Macdave_19]

I reckon you should declare the x = 10 outside the sub at the very top that ways its public and can be used by any sub routine

[Richard Buttrey]

can some1 pls help me? i m beginner in writing some marco.
below r my code

private sub commandbutton1_click()
x=10
call part1
end sub

sub part1()
msgbox x
end sub

how to pass the x=10 to sub part1?

Hi,

I note your thread title was asking how to pass a parameter to another sub. The replies you've had, whilst achieving what you want, rely on explicitly declaring a variable, using that and ensuring that it is a) still in scope, and b) its 'life' hasn't passed.

Passing a parameter is somewhat different. The pair of brackets that you see at the end of every Procedure name, e.g. MyFantasticProcedure() are where the receiving Procedure defines the value that's being passed. So for instance if you want to pass the number 10, you'd use the following code.

Please Login or Register  to view this content.

and the MyF..P... would be

Please Login or Register  to view this content.

HTH

[royUK]

ccs_1981

Please read the Forum Rules & wrap your code with Code tags in future.