JohnZ1156
Board Regular
- Joined
- Apr 10, 2021
- Messages
- 160
- Office Version
- 2021
- Platform
- Windows
I have an Excel Workbook with many VBA macros. I also have a VBA function called SpellNumber that I got from an Excel Forum. (I don't remember if it was this forum or a different forum.).
The SpellNumber function works great to convert a numeric value into written text. Just like the amount on a check in text format.
My problem is that while I'm working on a completely different macro, having nothing to do with that function, if I test my macro in Single Step Mode, as I continue to press the <F8> function key, it jumps to this SpellNumber VBA function. I don't know why, but it's very annoying.
The SpellNumber function is in a module all by itself, and has the text, Options Explicit at the very beginning.
Can anyone please explain to me why this is happening, and PLEASE tell me how I can prevent <F8> from suddenly jumping to a completely different VBA script?
Thank you.
The SpellNumber function works great to convert a numeric value into written text. Just like the amount on a check in text format.
My problem is that while I'm working on a completely different macro, having nothing to do with that function, if I test my macro in Single Step Mode, as I continue to press the <F8> function key, it jumps to this SpellNumber VBA function. I don't know why, but it's very annoying.
The SpellNumber function is in a module all by itself, and has the text, Options Explicit at the very beginning.
Can anyone please explain to me why this is happening, and PLEASE tell me how I can prevent <F8> from suddenly jumping to a completely different VBA script?
Thank you.