Conditional Input

Tags: Help, XLW, Roles

Note: This page has been replaced by an updated and extended help page for WrapCreator at https://help.excelwraps.com/support/online-help/help-the-cinput-widget/

A conditional input cell becomes active if a user has a particular subdomain role and an enabling cell becomes TRUE. XLW's CINPUT() function is inserted into the cell.

REMEMBER: set Excel's debug user role using 'About XLW Subdomain' button.

In this example the enabling cell F17 must evaluate to TRUE and the user role must be 'AdminTenant' to activate the input. No default value has been set (this would be the initial entry in the input cell).

=CINPUT(F9,"AdminTenant","")