Excel VBA Editor hot key

Help Studio
,
1

Hi,
I am in Excel VBA code. To run the macro, I am sending hot key CTRL + home
and the hot key f5. This is not running the macro code.
Any suggestions please?

Thank you,

2

@A_Learner,

If your excel is on VBA Code editor window and your code have only one Function/Sub then send Keyboard Shortcut this way.

Ctrl+A - To Select whole code and this will avoid additional popup to select particular Sub Function to run
F5 - To Run

Thanks,
Ashok :slight_smile:

3

What does ctrl + home to do in VBA editor?
Also there is f5 but not F5 in send hot key. Is that okay?

Thank you,

4

@A_Learner,

Alt+F11 for to open VBA Editor

F5 is function key to execute macro.

Here is sample code you can refer.

image
image568×1361 51.9 KB

Workflow.xaml (11.5 KB)

Thanks,
Ashok :slight_smile:

5

This is asking me select the function name by showing the list of functions. Is there a simpler way? Thank you,

6

@A_Learner,

Ashok you are restricted to use enable macro, this is the only way.

If you are getting pop-up to select function to run, you will have to enter the name using Type Into activity and the press enter.

7

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.