|
|||||||||
|
|
|||||||||
| Project Description: | |||||||||
|
VBA Filter Macro filters the particular customer, entered in the customer wildcard and displays the filtered customer details. |
|||||||||
| Steps To Execute: | |||||||||
|
• Opening the VBA Filter, the initial view is seen as below |
|||||||||
![]() |
|||||||||
| Screen 1 | |||||||||
|
• To filter a particular customer click “Enter text customer wildcard” button. • A window opens comprising “Important” as window name and enter customer value as Text box. (see Screen -2) |
|||||||||
![]() |
|||||||||
| Screen 2 | |||||||||
|
• Now enter the required customer name in the text box • The text box after entering a customer name is shown below (see Screen 3) |
|||||||||
![]() |
|||||||||
| Screen 3 | |||||||||
|
• Click “Ok” button. • The Customer name entered in the text box is filtered and the particular customers details are shown below (Screen -4) |
|||||||||
![]() |
|||||||||
| Screen 4 | |||||||||
|
|