Set a picture as an excel userform background

Asked By bmcaro 10 points N/A Posted on - 05/27/2013

Hi guys,

I am have been using MS excel for a while now and I wanted to try adding image backgrounds to my work specifically how to set a picture as an excel userform background. What I would like is help on how I can do this through selecting a custom image background and setting it correctly. Anyone who can help me on this please reply to this post.

• Status: Open
• Question Views: 1292
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS Excel

Best Answer by Caldwell Llanos

Go To Solution

Best Answer

Best Answer

Answered By Caldwell Llanos 5 points N/A #130371

Set a picture as an excel userform background

 

Hi Bmcaro,

User-Forms can be made from an excel worksheet or by adding a Macro. If you are dealing with Macro’s then the previous post is one way. If you are pertaining to a plain worksheet then here’s how you can do it:

For Excel 2003:

1. Go to Format > Sheet > Background

For Excel 2007:

1. Look for Page-Layout > Background

 

Hope this helps!

About Caldwell Llanos

Questions
1

Answers
100

Best Answers
49

• Vote Up 0 Vote Down

• Posted on - 06/02/2013
• Question Category: MS Excel

Answered By Harvey Swiney 0 points N/A #130370

Set a picture as an excel userform background

Hi Bmcaro,

It is easy to set an image for your background. The only thing you need to do is click with your right mouse button your form and than select Properties, after which you look for the Picture property. Than you set your picture size mode and the alignment of your picture in your form.

About Harvey Swiney

Questions
3

Answers
101

Best Answers
6

• Vote Up 0 Vote Down

• Posted on - 06/03/2013
• Question Category: MS Excel