Need help creating VBA code to do the following. Thanks in advance.
To help choose icons (and the corresponding imageMSO value for the RibbonX code) use the Office 2007 Icon Gallery which is an Excel file that contains a custom tab displaying more than 3000 icons that can be used in your applications. Note: There is an Office 2010 Icon Gallery, but it is formatted into a custom Word Document and is less useful. There would be few icons that had changed that you probably wouldn't need anyway Note: When viewed in Office 2013, the icon styling, if different, for the new version would apply, Finding An Icon Download the Office2007 Icon Gallery: Run the .EXE file and unzip the files as instructed. By defal it creates a folder on the root of the c: named 2007 Office System Developer Resources Open the file and display the Developer tab to see the icon gallery Office2007IconsGallery.xlsm Microsoft Excel Developer Map Properties Import Expansion Packs oe Export Refresh Data Gallery 4 . allery 7 Gallery 5Gallery 8 Gallery 6 Gallery 2 Source PanelGllery3 Modify Gallery 9 XML Office lcons Look for a suitable icon for display a form that calculates average, and take note of it. Clicking an icon displays the name and two views of the icon, large and smal. Write it down if necessary and make sure to maintain proper capitalization as the names are case sensitive. Alternatively you can use a name such as HappyFace, or SmartArtAddBullet. This is the name you place in the ribbon later. To help choose icons (and the corresponding imageMSO value for the RibbonX code) use the Office 2007 Icon Gallery which is an Excel file that contains a custom tab displaying more than 3000 icons that can be used in your applications. Note: There is an Office 2010 Icon Gallery, but it is formatted into a custom Word Document and is less useful. There would be few icons that had changed that you probably wouldn't need anyway Note: When viewed in Office 2013, the icon styling, if different, for the new version would apply, Finding An Icon Download the Office2007 Icon Gallery: Run the .EXE file and unzip the files as instructed. By defal it creates a folder on the root of the c: named 2007 Office System Developer Resources Open the file and display the Developer tab to see the icon gallery Office2007IconsGallery.xlsm Microsoft Excel Developer Map Properties Import Expansion Packs oe Export Refresh Data Gallery 4 . allery 7 Gallery 5Gallery 8 Gallery 6 Gallery 2 Source PanelGllery3 Modify Gallery 9 XML Office lcons Look for a suitable icon for display a form that calculates average, and take note of it. Clicking an icon displays the name and two views of the icon, large and smal. Write it down if necessary and make sure to maintain proper capitalization as the names are case sensitive. Alternatively you can use a name such as HappyFace, or SmartArtAddBullet. This is the name you place in the ribbon later
