Most of people have a standart to format they write, it’s will be quickly if we have a shortcut key our combination format, with VBA on Excel we can make it :1. Open Excel 2. Click Develepor |Visual Basic / ALT + F113 3. Click Insert | Module
4. Copy Code this code into module Sub Combi() With Selection.Font .Name = "Arial" .Size = 11 .Bold = False .Italic = False .Strikethrough = False .Superscript = False .Subscript = False End With With Selection .MergeCells = False .WrapText = False End With End Sub 5. To make our combination format - To Change the Font just type the name our Font such “Algerian” - To Change the size just change the number such 18 - To Change another format such Bold, MergeCells just replace False with True - And Name Procedure (Combi) can you change with name you like. 6 . After that go back to Excel and Click Develepor | Macro 7. Choose Combi and Click Options 8. Type the Shortcut Key you want such CTL + SHIFT + C, Click Ok, and to Exit Click Cancel , 9. Click Office Button and Save As Excel Add-In(xlam) 10. And To Activated Click Excel Option on Office Button 11. Click tab Add-In and Click Go Button 12. Choose Combi and Click OK, now you can use it. Download Tutorial -- Posting oleh mister.ahmad ke Tips and Trick pada 12/28/2009 02:12:00 AM -- You received this message because you are subscribed to the Google Groups "Gugukluhayat" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/gugukluhayat?hl=en.
