After having spent several years on this forum, I've come to understand how much many of you know about computers. I'd like to ask a simple question (no, I'm not going to ask you to write my code for me) about the user interface of the Excel VBA editor, and if you could please give me your best answer I would be most thankful.
Anyway, I've been trying to teach myself VBA for a summer research project, but I've been getting hooked on a small yet important detail: actually testing my code in the editor.
For whatever reason (it doesn't matter what code I've written), whenever I try to "run" my code (by clicking the green icon or pressing F5), a "Macros" dialogue box (see attached) pops up instead.
This wasn't a problem when I could test my code with the Workbook_Open event, but I've been needing to move on for quite a while now. I've spent several hours across several days trying to figure this out myself--both in books and the Internet--but nobody says anything beyond "...just press run and you should see..."
It is infuriating, and I feel that I've run out of options.
I'm sure this is a simple problem probably associated with the settings or something, so if you could please offer me a reason for why this might be happening and how I could fix it and move on with my research I would be very very grateful.