Hello All,
Can someone assist me with this? Sample file attached with a Vault boy Jpg (40213) and meme frown boy (40212) for reference.
What I would like to happen is that when If I type the name of the picture in the search field and click search, it will display the image. Clicking clear will remove the image displayed.
Many Thanks!
What name do you want to type? The number 40212 is the name of the object in Excel, but the name "meme frown boy" is unknown to Excel, even if that is the file name it came from.
Try:
Assign 'HidePics' to the 'Clear' button, and assign 'SearchPic' to the 'Search' button.
Please Login or Register to view this content.
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
I took a little different approach,implemented in attached. But you still need to think about what you mean by an image name.
Please Login or Register to view this content.
Hi All,
6StringJazzer hit the right spot! Calling the images based on the Object Name of the image would be the best approach. Thank you so much for the help! In case that I need to add more images in the selection, should I just add additional "S.Name = "Rounded Rectangle 2") and replace it with the correct values right?
No. Rounded Rectangle 1 is the name of the Clear button and Rounded Rectangle 2 is the name of the Search button. They are mentioned in the code so you don't hide the buttons when you are hiding the other images. You can add as many images as you want and don't have to change the code.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks