Adding menu item in VBA

**ateestructural** · 09-20-2017, 10:54 PM

Currently, I have a worksheet which has several data. I have created a button at the end of the sheet and when the user hits the button I call my VBA functions that do some computation.

Now, instead of the button I want to add a menu item (or an icon in the menu) so that when the user hits the icon I call my function to do the computation.

I do not know how to add the icon. Can anyone please help to add a custom menu item / icon in the menu ?

Thanks a lot

**sintek** · 09-21-2017, 05:35 AM

Hi ateestructural...

How did you create your button...Form or Active X control...
To add a icon button or image...just download required image and insert image into sheet. Then right click on image and assign your macro...

**xlnitwit** · 09-21-2017, 05:46 AM

Hi,

Where in the menu do you want the button? If the Add-Ins tab is acceptable, you can use code (using Commandbars) to add it; otherwise you will need to modify the CustomUI part of the workbook- http://www.rondebruin.nl/win/s2/win001.htm