EXCEL Set a cell’s validation function

This article describes the RPA Excel functionality to set a cell’s validation.

For a full list of available functions, please read EXCEL functions.

Description

The EXCEL Set a cell’s validation function allows you to set a cell’s validation.

Setting it up

To use the EXCEL Set a cell’s validation function, follow these instructions:

{{popups:rpas/add:action=excel-validation-set}}

Once on a process map:

1. Navigate to the process where you would like to add the EXCEL Set a cell’s validation function
2. Click on the green button’s drop-down (right side of the green button labelled “Process”)
3. On the menu that appears, click on the “+ Activity” item
4. From here you can select the EXCEL Set a cell’s validation option
5. Click "Add" once you are done

Input parameters

Output variables

This action does not produce output variables.

Errors

Tips

• Creates a dropdown list validation on the specified cells
• Each line becomes an option in the dropdown

Related functions

• excel-validation-get
• excel-validation-clear