VBA Command Button to Insert and Size multiple photos

%3CLINGO-SUB%20id%3D%22lingo-sub-1781905%22%20slang%3D%22en-US%22%3EVBA%20Command%20Button%20to%20Insert%20and%20Size%20multiple%20photos%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1781905%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%20Wondering%20if%20I%20can%20get%20some%20help.%26nbsp%3B%20I%20am%20trying%20to%20use%20one%20command%20button%20to%20insert%20multiple%20photos%20and%20have%20them%20sized%20to%20different%20cells.%26nbsp%3B%20I%20am%20trying%20different%20commands%20but%20nothing%20seems%20to%20be%20working.%26nbsp%3B%20Anyone%20have%20any%20assistance.%26nbsp%3B%20Will%20I%20need%20one%20command%20button%20to%20open%20documents%20to%20select%20the%20photos%20and%20another%20to%20size%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1781905%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1782607%22%20slang%3D%22de-DE%22%3ESubject%3A%20VBA%20Command%20Button%20to%20Insert%20and%20Size%20multiple%20photos%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1782607%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F832900%22%20target%3D%22_blank%22%3E%40JPerry1450%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3EHere%20is%20a%20file%20as%20I%20understood%20it%20in%20your%20message.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%20class%3D%22%22%3ESince%20I%20do%20not%20know%20in%20advance%20what%20exactly%20you%20want%20to%20do%20with%20it%2C%20whether%20it%20is%20pictures%20or%20graphics%2C%20as%20well%20as%20for%20which%20Excel%20version%20you%20need%20it%2C%20I%20ask%20you%20to%20try%20this%20out%20in%20your%20Excel.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20the%20future%2C%20if%20I%20may%20suggest%2C%20please%20add%20a%20file%20(without%20sensitive%20data)%20and%20describe%20your%20plan%20on%20it.%20The%20error%20could%20be%20identified%20faster%20and%20more%20specifically.%3C%2FP%3E%3CP%3EPlease%20no%20picture%2C%20even%20if%20it%20is%20said%20that%20a%20picture%20is%20worth%20a%20thousand%20words%2C%20it%20is%20definitely%20not%20in%20the%20case%20of%20Excel.%3C%2FP%3E%3CP%3EThis%20means%20that%20you%20can%20be%20helped%20more%20quickly%20and%20the%20best%20possible%20solution%20tailored%20to%20your%20needs%20can%20be%20offered.%3C%2FP%3E%3CP%3ESo%20everyone%20is%20helped.%3C%2FP%3E%3CP%3EHelp%20to%20be%20helped.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E*%20It's%20always%20good%20to%20add%20your%20operating%20system%20and%20Excel%20version.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20understanding%20and%20patience.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20be%20happy%20to%20know%20if%20I%20could%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E*%20Kindly%20Mark%20and%20Vote%20this%20reply%20if%20it%20helps%20please%2C%20as%20it%20will%20be%20beneficial%20to%20more%20community%20members%20reading%20here.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hello,

 

  Wondering if I can get some help.  I am trying to use one command button to insert multiple photos and have them sized to different cells.  I am trying different commands but nothing seems to be working.  Anyone have any assistance.  Will I need one command button to open documents to select the photos and another to size?

2 Replies
Highlighted

@JPerry1450 

Here is a file as I understood it in your message.
Since I do not know in advance what exactly you want to do with it, whether it is pictures or graphics, as well as for which Excel version you need it, I ask you to try this out in your Excel.

 

For the future, if I may suggest, please add a file (without sensitive data) and describe your plan on it. The error could be identified faster and more specifically.

Please no picture, even if it is said that a picture is worth a thousand words, it is definitely not in the case of Excel.

This means that you can be helped more quickly and the best possible solution tailored to your needs can be offered.

So everyone is helped.

Help to be helped.

 

* It's always good to add your operating system and Excel version.

 

Thank you for your understanding and patience.

 

I would be happy to know if I could help.

 

Nikolino

I know I don't know anything (Socrates)

 

* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.

Highlighted

Sorry,

 

  Here is an example of what i am looking for.  Using 1 command button to upload multiple photos and size to cells.