Hi, every one my code below is for an image thing in a user form in vba. When the image is clicked on, this code will display a file picker to enable a user to select an image which calls a functions to do this, inputting the selected image into a worksheet. That all works fine and correct, however my problem is that it allows files and other things to be inputted into the worksheet which I don't want it to!!! If every one could help me with this I would be grateful!!!
Hi,
Can I suggest you upload the workbook, and tell us which image you are clicking.
And assuming this pops up a standard Windows File Open dialog box, how is the macro to know whether the file that's being picked is not one that you want to bring in. Excel is not psychic. You may not know what's invalid but you need to provide a rule for Excel to work with.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
that's my problem really, I don't know how to tell the macro to only select and input an image.
Originally Posted by jakeembx
You may not know how to tell the macro to do it but you do do it manually? In your mind you must make some decision about which file/image to use or reject. Tell us what your thought process is and that will help decide how to encapsulate that in VBA. At it's simplest the rule may just be 'reject unless a .jpg file'. Or maybe you can only test the image after its imported, and then you could delete it or not if it doesn't meet whatever your criteria may be.
One way or another you have to 'write down' the rule for us.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks