+ Reply to Thread
Results 1 to 5 of 5

Change background image on individual multipage userform pages using vba

  1. #1
    Registered User
    Join Date
    07-10-2013
    Location
    uk
    MS-Off Ver
    Excel 2010
    Posts
    3

    Change background image on individual multipage userform pages using vba

    Hi All,

    Just wondering if there is any way to change the background image on a multipage userform through vba?
    Basically the problem is that I want the background to change based on the contents of a combo box, I know there is a thread on here somewhere that talks about changing the background of the userform via vba but I just can't seem to work out how to do it if you are in a multi page.

    Thanks very much!

    Stephen B

  2. #2
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Change background image on individual multipage userform pages using vba

    you can change the Picture property of a page. where are the pictures located? if on disk you can use loadpicture
    Josie

    if at first you don't succeed try doing it the way your wife told you to

  3. #3
    Registered User
    Join Date
    07-10-2013
    Location
    uk
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Change background image on individual multipage userform pages using vba

    Thanks for the quick reply!
    Yeah I tried the loadpicture thing using a bit of code like this:
    Please Login or Register  to view this content.
    But I'm pretty sure my syntax is incorrect- it doesn't pick up that Page1 has a picture option or something...

  4. #4
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Change background image on individual multipage userform pages using vba

    are you getting an error? the syntax is ok as long as the control, page and file names are correct

  5. #5
    Registered User
    Join Date
    07-10-2013
    Location
    uk
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Change background image on individual multipage userform pages using vba

    Ahh wow I feel stupid - forgot the speech marks in the actual code! Thanks for the help there! Really appreciate it!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1