To display a pop-up form for a control, such as account number in a datasheet create a user interface (ui) macro that is associated with the event for the control.

On click event.

Explanation:

Spreadsheets are used to manipulate and represent data. It comes with so many functions, graphics, formulas, which can help to analyse data. Macro is a very powerful which found in spreadsheet like microsoft excel and access database.

It is used to shorten a multiple event process to just one click. Once the macro recording starts, it saves every event of the input command. This saved macro can be linked to an image, shape or icon.

1. b

2. c

3. b

4. a

5. b