format a picture with a macro?

**vamosj** · 10-11-2009, 02:17 PM

Check out this post by Leith Ross.

http://www.excelforum.com/947504-post2.html

Let me know if it needs some more explenation and I'll try and help.

Since you are using "Print Screen" we can probably just use a value to resize it to instead of 50%

**l2g** · 10-11-2009, 02:52 PM

I'm attempting to make the code work... Though how do I attach a shortcut key command to it?

Thanks

**l2g** · 10-11-2009, 03:21 PM

I'm afraid I'm not as skilled enought with VB to make that code work. I just know the very basics....... How do I select the picture to resize? Not sure what to put in place of "expression"

**vamosj** · 10-11-2009, 05:21 PM

Considering that you are using "Print Screen" to capture parts of your video let's go ahead and introduce you to the Macro Recorder. This little baby helped me to get where I am today in using VBA (as rough as I still am).

Since each image is going to be coming in the same size (resolution) we can use the macro recorder to record your first resizing operation then we can assign a shortcut key to do the operation for you.

Follow these instructions and you should be good to go.

Hit Print Screen for any part of your video to capture your first image to work with.
open up your excel document used for your notes.
click where you are going to put this image.
Now on the toolbar where you have file, edit, view, etc..... select Tools - Macro - Record New Macro
Name your macro whatever you want.
Under where you name the macro you should a place you can assign a shortcut key. it'll have ctrl + ___ Just assign a letter, like the letter m you wanted to use.
Hit okay
Now go ahead and paste the picture and resize it to the size you want. (Right click on the picture, select format picture, size).
Once you hit okay to resize it you can now stop your macro recording. Don't select any cell's until after you stop. You can do this by hitting the stop on the floating button that should be hanging around or once again selecting tools, macro, stop recording.
From here you all you'll have to do is hit your print screen, hit the cell you want to paste the image into, then hit ctrl + whatever letter you chose.

Hopefully this helps you out. Just remember, Macro Recorder can be a great friend to you, but once you start recording it will pretty much capture anything you do, so if you select the cell you are going to paste into after you start the macro recorder, then if you do the macro, it's going to select that cell again.

**l2g** · 10-13-2009, 09:12 PM

Thank you for the detailed explanation, though I tried it and it does not work. Excel is not able to record formatting/resizing a picture via a macro recording, unfortunately......