+ Reply to Thread
Results 1 to 14 of 14

Excel VBA: USERFORM simulate button click on image

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    08-22-2017
    Location
    USA
    MS-Off Ver
    2016 WINDOWS and MAC
    Posts
    294

    Re: Excel VBA: USERFORM simulate button click on image

    Hi All,

    I guess I was misinterpreting what the MouseDown/Up events actually are. I didn't realize they are what I want!

    So, I made two buttons and changed the images and some code (see attached). Works awesome!!

    Two issues persist: 1) How do I get the background image in a .GIF to be transparent? Since microsoft doesn't allow PNGs (another great work of the geniuses at MS), what are my options for image formats that supports transparency AND HIGH QUALITY ?
    EDIT: I had not realized .GIF format supports transparency. This question solved.



    Lasty, 2) This works great but performance is rather sluggish. I think I already know the answer to this question. I assume there's no way to improve the responsiveness of the "button" after consecutive events?

    Thanks for everyones help and time.
    Attached Files Attached Files
    Last edited by ironfelix717; 08-30-2018 at 09:10 PM.

  2. #2
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    England
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,980

    Re: Excel VBA: USERFORM simulate button click on image

    Quote Originally Posted by ironfelix717 View Post
    another great work of the geniuses at MS
    A couple of small observations:
    1. I bet that if I picked apart a program you made 20 years ago I could probably make fun of your decisions too with the benefit of a lot of hindsight. (Now if you want to mock their decision not to support VBA properly, I'll join you. )
    2. I personally (and I know this is true of others) am put off answering questions by people who complain about the tools all the time. Just something you may want to consider. Or not. Entirely up to you. But I pretty much guarantee those programmers were smarter than you or me.
    Everyone who confuses correlation and causation ends up dead.

  3. #3
    Forum Contributor
    Join Date
    08-22-2017
    Location
    USA
    MS-Off Ver
    2016 WINDOWS and MAC
    Posts
    294

    Re: Excel VBA: USERFORM simulate button click on image

    Quote Originally Posted by rorya View Post
    A couple of small observations:
    1. I bet that if I picked apart a program you made 20 years ago I could probably make fun of your decisions too with the benefit of a lot of hindsight. (Now if you want to mock their decision not to support VBA properly, I'll join you. )

    2. I personally (and I know this is true of others) am put off answering questions by people who complain about the tools all the time. Just something you may want to consider. Or not. Entirely up to you. But I pretty much guarantee those programmers were smarter than you or me.
    Oh, no dispute there on your guarantee they are and were smarter than us. I mean, office developers probably don't need to rely on the Excel Forum for questions on basic programming tasks like I do

    However, mocking their lack of support is no more right, wrong, or indifferent than complaints of their (lack of) tools. Regardless, both aren't suited for this thread. I'll try to bite my tongue in the future.

    Thanks

+ 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] Excel UserForm. Click Button to open explorer and go to URL within a text box
    By stevefisher85 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-19-2016, 06:09 AM
  2. Button Click on Spreadsheet commanded by Button Click on Userform
    By Quilie19 in forum Excel Programming / VBA / Macros
    Replies: 33
    Last Post: 04-07-2015, 11:35 PM
  3. [SOLVED] Navigating IE via VBA, click on specific image/button
    By Skybeau in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-12-2014, 06:29 PM
  4. Are there any experts in Excel out there? Trying to simulate a physical double click
    By eugeneaeria in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-03-2014, 07:10 PM
  5. Replies: 2
    Last Post: 01-30-2014, 07:52 PM
  6. Show Monthview via Image Click in Userform
    By siobeh in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-05-2013, 11:55 AM
  7. Code a Command Button on UserForm not to close upon click - Excel VBA
    By eemiller1997 in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 12-14-2012, 02:20 PM

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