none
VBA help RRS feed

  • Question

  • Hello,  

     

    I need help setting up a code for VBA.  I want to put a button in that would resize an image that I had just pasted into VBA.  The image would be copied from another program pasted in and then I would like to be able to click the button to resize the image into a set area.  If anyone could help me I would greatly appreciate it.  

     

    Thanks,

    AAA

    • Moved by Liliane Teng Wednesday, July 27, 2011 2:26 PM (From:Visual Basic Express Edition)
    Tuesday, July 26, 2011 3:20 AM

All replies

  • Hello AAAceph,

    Hello,  

     

    I need help setting up a code for VBA.  I want to put a button in that would resize an image that I had just pasted into VBA.  The image would be copied from another program pasted in and then I would like to be able to click the button to resize the image into a set area.  If anyone could help me I would greatly appreciate it.  

     

    Thanks,

    AAA

    for vba question , ask in ths forum

     

    Best Regards.

     

    Carmelo La Monica


     http://community.visual-basic.it/carmelolamonica/
    Tuesday, July 26, 2011 6:16 AM
  • Hi AAAceph,

    I moved this thread to Visual Basic for Applications (VBA) forum as Carmelo suggested. Here you may get more better and quicker support. And more this aspect experts live here. Thanks for your understanding.

    Have a nice day.

    Best regards


    Liliane Teng [MSFT]
    MSDN Community Support | Feedback to us
    Get or Request Code Sample from Microsoft
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    Wednesday, July 27, 2011 2:30 PM
  • This question is already in VBA forum.. http://social.msdn.microsoft.com/Forums/en/isvvba/thread/aee228a8-c965-4108-8884-ba30fea464ad
    Tiago Cardoso VB / VBA Analyst
    Wednesday, July 27, 2011 2:44 PM
  • Hello,  

     

    I need help setting up a code for VBA.  I want to put a button in that would resize an image that I had just pasted into VBA.  The image would be copied from another program pasted in and then I would like to be able to click the button to resize the image into a set area.  If anyone could help me I would greatly appreciate it.  

     

    Thanks,

    AAA


    Most often, though not always, the best way to solve these kinds of issues is to use the macro recorder. Turn it on, use the UI to do what you want, turn off the recorder, switch to the VBE, and see what code Excel generated.

    To generalize this code, share it here and someone should be able to help you. You may also want to see

    Beyond the macro recorder

    http://www.tushar-mehta.com/excel/vba/beyond_the_macro_recorder/


    Tushar Mehta (Technology and Operations Consulting)
    www.tushar-mehta.com (Excel and PowerPoint add-ins and tutorials)
    Microsoft MVP Excel 2000-Present
    Wednesday, July 27, 2011 9:12 PM