Using Excel 2003 sp3
I have a simple userform with 2 commandbuttons. Commandbutton1
executes some code, macro1, that reads some data from the worksheet
and displays it on the userform...no problem. Commandbutton2
executes some code macro2, that reads some user input on the form and
further processes the data. The problem is that macro2 cannot access
variables defined in macro1.

It seemed to me that I could solve this by setting up public
variables, but either I am wrong or am not setting it up correctly.
Can someone please help?
thanks
chuckm