As my program gets bigger I am finding that my lap top is crashing out in excel and vba excel.
The program file itself is only 7040kb....so far and I have only really started to begin.
So I have a series of little questions here that might get me on my way:
1. Should I be using a desk top and if so how much ram, memory should I be using? I think the program itself will get at 5x larger before i am done. Right now I am getting the message "APPCRASH" all too frequently. How can I fix or should I just upgrade my systems?
Right now I am running an Intel (R) core (TM) i5-3230m CPU @260 GHz, 6.00GB, 64 bit operating system, with windows 8 and Lenovo 2012 is the brand of computer. I just bought it 3 months ago new and have not used it for any other purpose than programming and I have a good antivirus software on it.
2. Right now the computer screen blinks on and off continuously. I think it is because I have a timer but even when I "comment" out the timer the screen still blinks.
3. I have essentially the same change event on different worksheets but all under the sub: Private sub. I am assuming that because the names are the same there is no cross over. Each private sub does something in its particular spreadsheet. Maybe I need to name the private subs something different. Can anybody suggest a different way to mention the sub name?
All in all I am trying to make it so my computer program does not crash and that I can keep on building my code.
General questions I know but then again I am not sure what the exact questions are that I should be asking in respect to all of this.
thanks for your help.