When did you use Microsoft excel VBA

Use microsoft excel vba when do:
1. Repetitive task (search and find)
2. Modified task

But the basic is excel menu itself. The VBA is just its complement.