Macro Exercises - Recording
Exercise 1
Record a Formatting Macro that formats the cells as Comic Sans,11,back color is yellow and font
Exercise 2
Accept the name from the user and display some message
Exercise 3
Create a macro called Sortdata that sorts data horizontally or vertically based
on the selection
Macros
used when we have repititive tasks, long process
set of actions that u record or a set of tasks u wnt to execute
Tools--Macro--Record new macro
wwwww
wwwww
ccccc
cccccc
sss
1,back color is yellow and font color is red
Historical USA ffsdfsdf
British Isles sdfdsfdsf
British Isles sdfdsfdsf aaa
Europe 10 Days sdfsdf aaa
African Safari dfds aaa
Historical USA aaa
British Isles aaa
Europe 15 Days aaa
African Safari Alt + F8=VB editor
Europe 15 Days
Amit
Geetha Amit
Harish
Vikram 34
Tarun Amit 56
Deepa Geetha 12
Kiran Harish 45
Seema Vikram 66
Praksh Tarun
Rishi Deepa
John Kiran 3 1
Rakesh Seema
Arun Praksh
Tina Rishi
Arjun John
Rakesh
Arun
Tina
Arjun
Geetha Harish Vikram Tarun Deepa Kiran Seema Praksh
Record macro--actio s--stop---ctrl + shotcut key on any selection will apply the macro
aaa
aaa kkk
aaa kkk
aaa kkk
aaa kkk
aaa kkk
5 2 7 4
Rishi John Rakesh Arun Tina Arjun
Customer TourName Agent
Larry British Isles Lindquist
Larry Europe 21 Days Black
Larry Europe 21 Days Fuentes
Chien Europe 15 Days Fuentes
Chien China Norton
Chien British Isles Norton
Chien Historical USA Wyatt
Kathleen Europe 21 Days Black
Kathleen British Isles Fuentes
Kathleen Yucatan Clay
Kathleen Historical USA Burr
Kathleen British Isles Clay
Kathleen British Isles Chang
Kathleen Europe 10 Days Clay
Doug African Safari Chang
Doug Historical USA Norton
Doug British Isles Wyatt
John Europe 15 Days Black
John African Safari Clay
John Europe 15 Days Clay
Rebecca Western Canada Clay
Rebecca Europe 21 Days Clay
Rebecca African Safari Black
Rebecca Historical USA Clay
Rebecca Europe 10 Days Lindquist
Rebecca Western Canada Wyatt
Cindy Europe 15 Days Wyatt
Cindy Europe 21 Days Wyatt
Cindy Historical USA Chang
Cindy Europe 21 Days Fuentes
Papa Europe 21 Days Wyatt
Papa Yucatan Chang
Papa African Safari Chang
Papa Europe 15 Days Clay
Papa Europe 21 Days Norton
Papa Russia and the Baltics Wyatt
Papa British Isles Chang
Robert British Isles Clay
Robert British Isles Clay
Robert Europe 15 Days Norton
Robert Historical USA Wyatt
Bart Western Canada Burr
Bart Yucatan Clay
Bart British Isles Fuentes
Todd Russia and the Baltics Burr
Todd Europe 10 Days Norton
Todd British Isles Black
Russell Europe 21 Days Fuentes
Russell Yucatan Fuentes
