Parameter macro

[corbinap]

I need a macro that is a parameter of 1 through 10 (or so), and for the parameter value, copy spreadsheet and clear which a user is not able to see.

Does anyone have an example or could help show me how to achieve. Thanks

 

[mintjulep]

These should help you.

http://www2.sims.berkeley.edu/courses/is208/s02/ReqsDoc.pdf

http://www.processimpact.com/articles/qualreqs.html

 

[firefytr]

I don't understand the question, nor do I understand minjulep's reply. I think I'm lost..

Regards,
Zack Barresse

Simplicity is the ultimate sophistication. What is a MS MVP? PODA
- Leonardo da Vinci

 

[xlbo]

What have you tried so far?

as a start

Sub Call_A_Parameter_Function()
Call ParamFunction(1)
End sub

Function ParamFunction(Arg1 as integer)
msgbox "Parameter PAssed was " & cstr(Arg1)
End Function

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[fumei]

Zack - BTW....hi!... it was nice to meet you in Seattle - mintjulep's post was to point out to the OP that it is a pretty good idea to write out clearly what are your requirements.

Which, of course, it is. IMO, an appropriate comment as the OP is not clear at all. The OP also has a slight smell of a homework assignment.

faq219-2884

Gerry
My paintings and sculpture

 

[corbinap]

Thanks

 

[firefytr]

Heya Gerry! It was absolutely great meeting you in Seattle as well. Maybe we could do it again sometime.

Regards,
Zack Barresse

Simplicity is the ultimate sophistication. What is a MS MVP? PODA
- Leonardo da Vinci