I wrote a big Macro Written in Excel 2003 and want to move it to Excel 2007 and it does not work at all.
I think I need to set up a module but don't know if its a class module or a regular module. I need to create a space to store about 300 constants and be able to reference them in about 8-10 Subroutines.
I think logically, they should be stored as public but I'm lost after that.
Also, I think I want to use a dialog box (form) instead of multiple input boxes
(and message boxes which I was using). I use access - so I know how to create forms - but again
- Where do I enter the code?
Posted by: email@example.com
|Reply via web post||•||Reply to sender||•||Reply to group||•||Start a New Topic||•||Messages in this topic (1)|