Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
MACROS WITH EXCEL
- Thread starter jimboyo
- Start date
Tolls>Macro>Record New Macro
Do some actions in excel
Press the STOP button (the square one) then go to the Visual Basic Editor (Alt + F11)
and have a look at what's there Rgds
Geoff
"Some cause happiness wherever they go; others whenever they go."
-Oscar Wilde
Do some actions in excel
Press the STOP button (the square one) then go to the Visual Basic Editor (Alt + F11)
and have a look at what's there Rgds
Geoff
"Some cause happiness wherever they go; others whenever they go."
-Oscar Wilde
Easiest way is to turn on the macro recorder...
Tools>Macro>Record new macro...
then go through a series of actions in your spreadsheet as you normaly would,.. actions like cut or copy and paste,....select different sheets, or an object like a chart and change some stuff.
then stop the recorder,... and hold down Alt while pressing F11 (this takes you to the vba editor,) the you can examine the code that the macro recorder wrote.
If you know some VBA statements or commands, you can then edit or modify the code to do things on conditions or pass variables to the code.
Tools>Macro>Record new macro...
then go through a series of actions in your spreadsheet as you normaly would,.. actions like cut or copy and paste,....select different sheets, or an object like a chart and change some stuff.
then stop the recorder,... and hold down Alt while pressing F11 (this takes you to the vba editor,) the you can examine the code that the macro recorder wrote.
If you know some VBA statements or commands, you can then edit or modify the code to do things on conditions or pass variables to the code.
- Status
Similar threads
