Record a key combination in a macro code

[Alexxu]

Hello.

I tried to record a macro that will run a key combination.
I have some UDF and to know what are the formula components, i have to always use Ctrl+Shift+A to see them.

Is there a way to record this combination?

Thanks!
-- removed inline image ---

 

[boileauj]

Have you tried to record this action as a macro to see if anything comes up for it?

Developer > Record Macro > "Macro 1"

Then open up VB Editor (Alt + F11), go to the Module 1 and see if anything appears under Macro1 when you use your command Ctrl +Shift + A.

I am not familiar with UDF or the properties that you mentioned, but this might work to find out if anything is recorded.

 

[Alexxu]

I already tried this and it is recording nothing.
I will probably do this manually if there is no other way to do it.

Thanks!

 

[snowblizz]

<code>Application.SendKeys("</code>^+a")

Will simulate the pressing of Ctrl+Shift+a

 

[Alexxu]

Now i realised.
I cannot run a macro while a try to write a function.

Thanks for your help!