I have variables declared in the code for the Sheet1 (mLength,mWidth,mHeight) that once they have their values have been set I want to access it by the code for the command button in the Module. But for life of me I can't work our why the button isnt doing what the test code is set up for.
I have gone through page after web page looking for solutions and havent found anything that works. I thought declaring the variables as Public would have made them accessible through all parts of the spreadsheets code.
Bookmarks