Put any automated task at your fingertips with a simple right-click

Hiltz, Kara
November 2009
Inside Microsoft Office (15506622);Nov2009, Vol. 6 Issue 11, p1
The article offers ways on how to put up macros with the use of visual basic for application (VBA). It notes how macros can be run through shortcut menus, such as a macro that changes the font or color in the active cell and applies specialized number formatting. An overview of the steps to build a macro is offered.


Related Articles

  • PLC with PIC16F648A Microcontrol - Part 13. Uzam, Murat // Electronics World;Nov2009, Vol. 115 Issue 1883, p42 

    The article features six multiplexer (MUX) macros that are part of Dr. Murat Uzam of Nigde University's project on microcontroller-based programmable controller (PLC). It states that the MUX enables the selection of one input signal among n signals as a standard combinatorial component. It notes...

  • MACROS OF THE MONTH.  // Australian PC User;Jul2009, Vol. 21 Issue 7, p88 

    The article presents information on this month's Microsoft Excel macro. This Excels macro runs on a worksheet only once. The process is controlled by writing data to a file, which indicates when the file has been opened and run at least once. The 'Do not display again' checkbox is disabled by...

  • Macro.  // Network Dictionary;2007, p298 

    A definition of the term "Macro" in computer science is presented. The term refers to an abstraction that defines how a certain input pattern is replaced by an output pattern according to a defined set of rules. There are three broad categories of macros: Programming macros, Application macros...

  • Identify cells with conditional formatting -- and the number of conditions -- in seconds. Soos, Kara // Inside Microsoft Office (15506622);Jul2012, Vol. 9 Issue 7, p1 

    The article focuses on the conditional formatting of a Microsoft excel worksheet. It says that a macro will add an informative comment on the cell to indicate the number of conditions existing on the cell, in which the cells that look out of place can be identified and correct the conditional...

  • Make your macro available in every workbook. Nebel, Stephen // Inside Microsoft Excel;Oct2010, Vol. 17 Issue 10, p5 

    The article provides information on making macros available to every MS Excel workbook by moving them into Personal.xls. The author says that a user can hide or unhide macros through a customized Excel 2000-2003 toolbar or the Excel 2007 Quick Access Toolbar, and the only thing that is needed...

  • Fill in data gaps automatically - even with blank rows standing in your way. Hiltz, Kara // Inside Microsoft Excel;Oct2010, Vol. 17 Issue 10, p6 

    The article discusses how to use MicroSoft Excel's AutoFill feature in filling in copying a cell value down a worksheet's column while skipping blank rows that separate data sections through a simple macro. The author outlines the creation of Visual Basic for Applications code for the macro, the...

  • Save Time With Hotkeys, Macros, and Gestures. Murphy, David // PCWorld;May2011, Vol. 29 Issue 5, p93 

    The article discusses the use of hotkeys, macros and mouse gestures to automate the most frequent personal computer (PC) tasks and save time. A hotkey pertains to a single button for performing a single action such as opening a folder. A macro refers to a chain of programmed actions occurring...

  • Change the Page. Schiller, Brad // Projection, Lights & Staging News;Feb2015, Vol. 16 Issue 1, p57 

    The article discusses aspects of automated lighting console allowing multiple banks or pages of playbacks, an essential tool for lighting programmers. Organizing playbacks with pages whether used for songs, theatrical acts or tech pages is mentioned. Topics include how pages are used in concert...

  • Domain-Specific Language.  // Network Dictionary;2007, p160 

    An encyclopedia entry for "Domain-Specific Language (DSL)" is presented. Associated with computer software, this term refers to a programming language used for specific tasks. It is also known as domain-specific programming language. Examples of DSLs are spreadsheet macros and YACC for parsing...


Read the Article


Sorry, but this item is not currently available from your library.

Try another library?
Sign out of this library

Other Topics