Im using a VBA function that I wrote, but it executes each time I add or delete a cell on the worksheet. Whats going on?
You probably have a cell somewhere on the worksheet that has a Function inserted, and that function uses your VBA function. The cell value is recalculated each time the sheet is updated, and your function is executed during the recalculation. If you can’t find the particular cell that’s causing the problem, copy the cells you want to keep onto another worksheet, and delete the original worksheet. Make sure the cells you copy don’t use the VBA function in their formula’s. This problem can also happen if you are using cell functions from an Excel AddIn. The fix would be the same as above. I wrote a VBA function to use in an spBasic program. I put a break statement in the function to debug it, but when I trace through the function I get an spBasic error at the end If you are writing VBA routines for use in spBasic, and you are tracing the routine flow using ‘break’ statements in your routine, make sure you press the ‘Continue’ button before you exit your routine. You can press the ‘Contin
Related Questions
- Word on the street is that Administrators are going to have to clock in and out everyday under the new Time & Labor system. Is that true?
- Can a custom worksheet function written in VBA perform the same types of actions as a subroutine?
- Why does Format(Now, "mm:ss") fail in VBA erratically whereas the TEXT() worksheet function works?
