can add icons as buttons without add commandbutton on userform

MKLAQ

Active Member
Joined
Jan 30, 2021
Messages
429
Office Version
  1. 2016
Platform
  1. Windows
Hi,
I'm not sure what I ask maybe could in excel.
as known when add icon into commandbutton on form will not show the caption clearly after upload icon . I have to resize the button then will be much big to show caption. my goal I will design the button by PHOTHOSHOP and I will upload to excel.
my question is: can I add the icon as picture on form without add commandbutton like inside sheet will use some shapes (rectangular, oval) and link it with macro?
 
Alternatively, to do it manually, you can just open the file in MS Paint, select and copy the image, and then literally go and ctrl-v paste it into the picture property of the control. Here is a demo of @sancarn doing it:
wow !!
I didn't know this way is available . for me I will take this way instead of using code and change EXCEL setting .
Personally, though, I tend not to add images to controls at design time. I usually find that the 'heavier' the userform is with controls and images and code, the more likely it is that something will go horribly wrong and the userform will be corrupted... which happens to me a lot!
umm, this comment is very useful through your experience until if happen for me then I understand what's the problem.:biggrin:
thank you so much for your solution.(y)
 
Upvote 0

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.

Forum statistics

Threads
1,224,837
Messages
6,181,255
Members
453,028
Latest member
letswriteafairytale

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top