How To Customize The Right Click Menu In Excel + FREE Template

preview_player
Показать описание
Take control of Excel’s right-click menu and make it work your way.

In this VBA Basic training, I show you how to create your own right click menu items, complete with icons, and custom drop-down lists via the context menu.

In This Video, You’ll Learn:
✓ How to add custom right-click menu items in Excel
✓ Build dynamic drop-down lists inside the context menu
✓ Add icons to your custom options using a free icon library
✓ Inject smart, interactive tools right where users need them
✓ Follow along and build your own right-click functions from scratch

👇𝐃𝐎𝐖𝐍𝐋𝐎𝐀𝐃 𝐓𝐇𝐈𝐒 𝐖𝐄𝐄𝐊'𝐒 𝐖𝐎𝐑𝐊𝐁𝐎𝐎𝐊 𝐓𝐄𝐌𝐏𝐋𝐀𝐓𝐄 𝐇𝐄𝐑𝐄:

🛠 𝐍𝐄𝐄𝐃 𝐇𝐄𝐋𝐏?

𝐄𝐗𝐂𝐄𝐋 𝐂𝐎𝐔𝐑𝐒𝐄𝐒:

𝐄𝐗𝐂𝐄𝐋 𝐏𝐑𝐎𝐃𝐔𝐂𝐓𝐒:

Timestamps:
0:00 – Introduction
2:30 – Overview
4:10 – Add Command Bar Button
5:36 – Button Clicked
10:21 – Sheet Before Right Click
12:57 – Deactivate Worksheet
20:41 – My Popup Clicked

𝐅𝐨𝐥𝐥𝐨𝐰 𝐌𝐞 𝐎𝐧 𝐌𝐲 𝐒𝐨𝐜𝐢𝐚𝐥 𝐌𝐞𝐝𝐢𝐚 𝐀𝐜𝐜𝐨𝐮𝐧𝐭𝐬:

𝐀𝐛𝐨𝐮𝐭 𝐔𝐬:
I help Excel enthusiasts turn their skills into passive income—no need to trade time for money. If you enjoy these weekly videos, you can support Excel For Freelancers by grabbing one of our powerful tools to boost your Excel skills and chase your dreams.

New Training Video Uploaded Every Tuesday And Saturday!

𝙏𝙝𝙖𝙣𝙠 𝙮𝙤𝙪 𝙫𝙚𝙧𝙮 𝙢𝙪𝙘𝙝 𝙛𝙤𝙧 𝙮𝙤𝙪𝙧 𝙘𝙤𝙣𝙩𝙞𝙣𝙪𝙚𝙙 𝙨𝙪𝙥𝙥𝙤𝙧𝙩,
Randy Austin

#ExcelVBA #VBAForBeginners #ExcelContextMenu #ExcelMenu #ExcelRightClick #ExcelCustomMenu
Рекомендации по теме
Комментарии
Автор

Really enjoyed this one Randy! Very informative and useful. Thanks Again!!

paulcottrell
Автор

So if I understand the concept correctly, you can use this functionality to add right click event to a shape (rather than a cell) . Shapes by default in excel only have a click property (the OnAction call of a macro.) But you have no alternative so if you have this ability you can create a right click driven shape command button and have an alternate way of doing something when a shape is clicked , in this case by right click.)

malcolmsokol
Автор

Thank you so much Randy for this amazing video

SyedMuzammilMahasanShahi
Автор

Wow, I am truly amazed by your incredible talent! From every video I am impressed. I can't wait to see what you will do next time. Thank you so much.

JanBolhuis
Автор

This code is great! Thank you! However, i noticed that it does not work when trying to right click inside a table. How can i modify this to work with excel tables?

nap_boule
Автор

Yes, I'm shure will be a great interesting lesson

temyraverdana
Автор

Hello Sir, I would like a hotel management application if possible. I am facing difficulties in the hotel in which I work I would be grateful to you for helping me

SIKAmotivation
Автор

Hi Randy, I am having trouble downloading this workbook, BitDefender wont allow it even after I have stopped virus protection. Can you help please. Thanks.

LeonDilley
Автор

Je veux une application complète de gestion hôtelière

SIKAmotivation
Автор

Your performance is genuinely outstanding! Would you like to share your thoughts on my work?🙂🙏

ExcelExplorers
join shbcf.ru