UserForm modern look!

**ciapul12** · 01-04-2014, 08:09 PM

Hi Everyone!

This may be an obsolete question but I would like to understand why there's no option of changing the appearance of our userforms to a more modern.
what I mean is for example in the excel spread sheet we can use/create a modern looking buttons from shapes which look really good, I am wondering why Microsoft didn't include this option in VBA editor or at least update the command buttons, give us more options in terms of the appearance of our userforms, I know we can play about with the colors and etc. but still all userforms look very similar to each other.

What's your view on this?????

Dan

**Leith Ross** · 01-04-2014, 08:29 PM

Hello Dan,

The easiest method to modernize a UserForm is to set the Picture property to a picture of your choosing. There are other things can be done like changing the shape but this requires using the Windows API.

**ciapul12** · 01-04-2014, 08:37 PM

Have you got any samples?
Thanks
Dan

**Leith Ross** · 01-04-2014, 08:54 PM

Hello Dan,

I probably do in my archives. There might be a few on line as well. If you do find some examples, a word of caution, the API is not very forgiving of programming errors. Generally, an API error will crash Excel or lockup the computer. If you are not sure the code works or is not from a reputable site, don't run it.

**ciapul12** · 01-05-2014, 09:39 AM

Hi Thanks for your replay.
Looks like It's not worth to try it....
Thanks

**Leith Ross** · 01-05-2014, 06:04 PM

Hello Dan,

Sorry for the delay. I have been fighting the flu for the past 3 days and the USB ports on my computer died.

Long story short, I have a an example workbook that will change the UserForm's shape in 3 different ways: Rounded corners, Ellipse, and Rhombus (more like diamond).

Checkout the workbook and let me know if this what you are looking for.