[Paid] Show picture on floating userform

[rolo]

Hello, I need to know if you can code this macro:

1. I will have an Excel like this

NAME	FACE PICTURE
Peter	C:\Images\Peter.jpg
Mery	C:\Images\Mary.jpg

2. My request: when I clic on a cell inside the table, I need a userform that shows the Face Picture inside. For example:
If I clic on any cell that belongs to "Peter" row, userform must show Peter asociated picture.
If I clic on any cell that belongs to "Mary" row, userform must show Mery asociated picture.
(selection change event, only when I am inside the table)

3. Userform located to the right of the table. It must be transparent and floating when scrolling
Transparent example here / Floating example here

Please, send me your estimated quote for this job (or ask me anything if it is not clear)

Thanks!

 

[chirayu]

this is something you can do yourself easily. see below video tutorial on youtube. Also attached sample. No cost

 

[rolo]

Although it's not exactly what I asked for, I really appreciate your example.

Thanks

 

[chirayu]

the transparent code you can just copy paste into the UserForm for the UserForm_Initialize bit. which should give you step 3. I tested the code from below - shorter than wellsr link you provided. also updated sample to make it easier for you.

Transparent (See through) userforms in Excel - VBA Visual Basic for Applications (Microsoft) - Tek-Tips

Question for you experts - Is there a way to take the userform I created for excel in Microsoft visual basic and make it transparent(See through)over my excel a

www.tek-tips.com

 

[rolo]

Hello Chirayu,

Thanks for your code, is much simpler!

Let me do some comments:


1. It only works with "jpg" images
Do you know why "png" images do not work? They show a "can´t load image" error...


2. I have to add this missing line in your macro to let userform show on selection change.




3. Do you know how to show image only (inside red square) without all that is outside red scuare? And avoid transparent effect?




Thanks!

 

[chirayu]

You might want to change the transparent code to this then. Unsure why doesn't take png

Remove Window Border Title Bar around UserForm with VBA - wellsr.com

This tutorial shows you how to hide the border on your UserForm using VBA. A UserForm without a title bar and X button are far cleaner than normal UserForms.

wellsr.com

 

[Chihiro]

PNG isn't natively supported in userform. It requires API call.

Check the sample workbook uploaded by Andy Pope in link below, see if you an adopt to your need.
https://www.excelforum.com/excel-programming-vba-macros/956417-insert-png-image-into-userform.html