How to set the value of a VBA variable with a command button

[Steve P]

I need to set a variable in my vba code from a command button...how is that
done?

 

[Marshall Barton]

I need to set a variable in my vba code from a command button...how is that
done?

simply use:
myvariable = something

But the usefulness of setting the variable depends on
where/how the variable is declared and where/how it is used.