+ Reply to Thread
Results 1 to 2 of 2

If then loop that calls filename of image within userform

  1. #1
    Registered User
    Join Date
    03-14-2014
    Location
    Wisconsin
    MS-Off Ver
    Excel 2010
    Posts
    9

    If then loop that calls filename of image within userform

    I have a userform (titled Userform1) that has an image (titled Image1) embedded in it. I'd like to write an if then loop that works based on the filename of the picture that is contained within the image. Something like this:

    Please Login or Register  to view this content.
    I apologize for being so archaic, but I am lost! haha Any ideas how I might be able to accomplish this?

  2. #2
    Forum Expert
    Join Date
    01-23-2013
    Location
    USA
    MS-Off Ver
    Microsoft 365 aka Office 365
    Posts
    3,863

    Re: If then loop that calls filename of image within userform

    Hi lp3eb,

    As far as I know, as soon as you embed an image in a UserForm, the original name is lost, unless you store the name somewhere. There are many places to store the name, including:
    a. A spreadSheet Cell
    b. A UserForm Control TextBox or Label which can be visible or hidden.

    Lewis

+ 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. [SOLVED] Userform calls other userform, then populate worksheet
    By Lehoi in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-03-2016, 06:50 PM
  2. [SOLVED] Using a Userform to Browse image file then paste selected image to sheet?
    By matrixpom in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-05-2015, 05:42 PM
  3. [SOLVED] How to apply Image borders to an image that my excel vba userform pastes in a word doc?
    By CaptainCool in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-11-2014, 05:40 PM
  4. [SOLVED] VBA to transfer image FROM userform image control TO a worksheet cell
    By Zoediak in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-01-2014, 02:51 PM
  5. Loop to do Whitepages API calls?
    By efarnham in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 08-18-2011, 03:50 PM
  6. Variable Filename calls
    By Grymjack in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-07-2006, 12:40 PM
  7. [SOLVED] Looping procedure calls userform; how to exit loop (via userform button)?
    By KR in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-27-2005, 08:05 AM

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