Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Control + Break equivalent for Mac in VBA

Tags:

macos

vba

If I want to stop my code from executing on a PC, I know I just need to press ctrl+break. But since my Mac has no "break" key I am not sure what to do?

What is the equivalent in Mac?

like image 695
lakshmen Avatar asked May 27 '13 19:05

lakshmen


3 Answers

Use . on Mac to stop the code.

like image 179
Santosh Avatar answered Oct 17 '22 12:10

Santosh


The . or ctrl ESC keys do not function exactly like on the PC. They do not break to the debugger on a modal dialog box. Use ESC ESC (Press the ESC twice) to bring up a dialog that allows you to enter the debugger at the location in code of the dialog box display. Tested in Excel VBA 2011

like image 29
Jeff Avatar answered Oct 17 '22 11:10

Jeff


cntrl-esc works like cntrl-break on my macbook pro to stop Excel vba running under Windows 7.

like image 2
ciso Avatar answered Oct 17 '22 12:10

ciso