afenrick86
New Member
- Joined
- Sep 4, 2014
- Messages
- 6
Alright, I need a little help with my image that I am selecting from a file. I don't know exactly where the image is located before I select it so I created a command button and tied this macro to it. Once I select the image that I want to insert into my worksheet the top left corner of the image is the last cell that I selected and it is whatever size the image originally was.
Private Sub CommandButton1_Click() Application.CommandBars.ExecuteMso ("PictureInsertFromFile")End Sub</pre>
I need to be able to tell the image which cell I want it to start in "E26" and that I want it to be no more than 500 pixels wide or tall while constraining its proportions. Any ideas?
Private Sub CommandButton1_Click() Application.CommandBars.ExecuteMso ("PictureInsertFromFile")End Sub</pre>
I need to be able to tell the image which cell I want it to start in "E26" and that I want it to be no more than 500 pixels wide or tall while constraining its proportions. Any ideas?
