can add icons as buttons without add commandbutton on userform

[MKLAQ]

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?

 

[RoryA]

Given that you are creating the image, why can't you just use a different file format?

 

[MKLAQ]

because the PNG doesn't contain color for back color if I convert to jpg will make white for back color .

 

[Dan_W]

No you don't. If you read the link I posted, you will see you can load the image from base64 strings. But if you don't want to use it thats ok.

 

[MKLAQ]

If you read the link I posted

in reality not yet.

you will see you can load the image from base64 strings

it can't save after close the form ?
so what's the aim for that if doesn't keep the picture without load every time run the form ?!

 

[Dan_W]

I'm sorry - I cannot understand your messages.
You want to save the image file after you close a form?

 

[MKLAQ]

You want to save the image file after you close a form?

yes if it's possible will be great.

 

[Dan_W]

I just don't understand what that means though.

 

[Artik]

I get the impression that the OP wants a one-time macro that will insert images into controls in Designer mode.

Artik

 

[MKLAQ]

I just don't understand what that means though.

if I have jpg picture and upload picture to commandbutton will keep the picture when run the form will show the picture as I uploaded, but in png picture when upload to commandbutton will not show the picture has ever uploaded when run the form after clos the form agian . based on your suggestion wen show browser and select picture to upload and when close the form and open again will not show uploaded picture . in png picture I have to upload picture for every time run the form .
I would the same way like JPG picture upload from first time then will show when every time run the form without I upload every time run the form.

 

[MKLAQ]

I get the impression that the OP wants a one-time macro that will insert images into controls in Designer mode.

yes that's correct.