cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jb0100
New Member

Send keys in excel, Curly brackets key is registered as text and not as parto of an expression, eg. {Enter}

Screenshot 2022-11-23 202226.jpg

 

Sending this to excel, the problem is that Alt works but after that the Curly brackets "{}" keys are counted as text, so excel makes a sound as if I pressed an "illegal" character.

 

Used a keylogger and ran the macro and the keypresses came out as: 

VK codesPositionKey
A4downLEFT ALT
A4upLEFT ALT
A0downshift
DBdown{
DBup{
A0upshift
58downX
58upX
A0downshift
DDdown}
DDup}
A0upshift
58downX
58upX
A0downshift
DDdown}
DDup}
A0upshift
A0downshift
DBdown{
DBup{
A0upshift
32down2
32up2
A0downshift
DDdown}
DDup}
A0upshift
32down2
32up2
A0downshift
DDdown}
DDup}
A0upshift
0DdownEnter
0DupEnter
09downTab
09upTab
0DdownEnter
0DupEnter
0DdownEnter
0DupEnter

 

So im totally lost... 

1 ACCEPTED SOLUTION

Accepted Solutions

Great! you can close the thread if its resolved now.

View solution in original post

3 REPLIES 3
VJR
Super User
Super User

I do not see any key as x when pressed even manually in Excel and it gives a sound of an illegal character.

VJR_0-1669262245588.png

 

 

So what is the x after the Alt in your message?

And which menu are you trying to activate?

 

jb0100
New Member

Hello

 

Its de add-ins menu.

 

I figured it out, {Alt}x2{enter}..... worked.

 

Thanks!!

 

Great! you can close the thread if its resolved now.

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Top Solution Authors
Top Kudoed Authors
Users online (2,049)