none
MS excel Vba macro ui RRS feed

  • Question

  • I am new in excel vba programming. I am building a macro like the image attached. I have searched but did not find a way to create its UI like the attached image. Please let me know if its possible or not, if yes, please provide me the links.

    Thank you so much

    Tuesday, December 16, 2014 8:00 AM

Answers

  • Hi sunilomey,

    >> I am building a macro like the image attached

    Where is the image?

    If you want to add image to excel file, if so, you could use Worksheet.Picutures.Insert method to achieve that.

    If you want to custom excel Ribbon, please refer to this links below:

    # Customizing the 2007 Office Fluent Ribbon for Developers

    http://msdn.microsoft.com/en-us/library/aa338202(v=office.12).aspx

    # Ribbon Overview

    http://msdn.microsoft.com/en-us/library/bb386097.aspx

    Best Regards

    Starain


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.

    Thursday, December 18, 2014 5:41 AM
    Moderator

All replies

  • Hi sunilomey,

    I am moving your thread into the Excel for Developers Forum for dedicated support. Thanks for your understanding.

    Have a nice day,

    Jack


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.

    Wednesday, December 17, 2014 8:49 AM
  • Hi sunilomey,

    >> I am building a macro like the image attached

    Where is the image?

    If you want to add image to excel file, if so, you could use Worksheet.Picutures.Insert method to achieve that.

    If you want to custom excel Ribbon, please refer to this links below:

    # Customizing the 2007 Office Fluent Ribbon for Developers

    http://msdn.microsoft.com/en-us/library/aa338202(v=office.12).aspx

    # Ribbon Overview

    http://msdn.microsoft.com/en-us/library/bb386097.aspx

    Best Regards

    Starain


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.

    Thursday, December 18, 2014 5:41 AM
    Moderator