+ Reply to Thread
Results 1 to 4 of 4

Background images for dynamic Userform

  1. #1
    Registered User
    Join Date
    12-03-2013
    Location
    United Kingdom
    MS-Off Ver
    Excel 2010
    Posts
    36

    Background images for dynamic Userform

    I am trying to create an image on which if a specific part is hovered over, the image hides and another becomes visible. I have done this by placing an image block over the first image and used the following code:
    Please Login or Register  to view this content.
    This works fine however, I dont want Image1 (the one that is hovered over) to be visible and just want the user to be able to see Image2 initially and just Image3 after the event occurs. To do this, I set Image1 visibility to false but now when I hover over its location nothing happens. For some reason this only works when the image is visible. Is there a way around this?

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Background images for dynamic Userform

    Hello sur4j,

    If you images are stored locally as files then you can use a single Image control and simply load the image from the file you need.
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

  3. #3
    Registered User
    Join Date
    12-03-2013
    Location
    United Kingdom
    MS-Off Ver
    Excel 2010
    Posts
    36

    Re: Background images for dynamic Userform

    This is a file that will be getting sent to others therefore, I would like to keep it as a single excel workbook if possible. Is there any alternative? Maybe, storing the images in the workbook somewhere rather than externally?

  4. #4
    Registered User
    Join Date
    12-03-2013
    Location
    United Kingdom
    MS-Off Ver
    Excel 2010
    Posts
    36

    Re: Background images for dynamic Userform

    Or, is there a way to make an image box 'see through' so that it creates the illusion that nothing is there?

    EDIT: Answered me own question :P

    Thanks for your help
    Last edited by sur4j; 04-10-2014 at 04:52 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Repeating background images
    By Steve in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 07-31-2006, 05:18 PM
  2. [SOLVED] problems with background images
    By Marilyn Jeffery in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 07:05 AM
  3. [SOLVED] problems with background images
    By Marilyn Jeffery in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 04:05 AM
  4. problems with background images
    By Marilyn Jeffery in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 01:05 AM
  5. [SOLVED] problems with background images
    By Marilyn Jeffery in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 07-05-2005, 03:05 PM

Tags for this Thread

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