webdevptg
Board Regular
- Joined
- May 2, 2019
- Messages
- 51
- Office Version
- 365
- 2019
- 2016
- Platform
- Windows
- Web
PS: translate by Google translate ?
Hi,
have a function VBA that verifies the Portuguese TIN is valid (Como validar um NIF no Excel - www.JJoao.com) through the control digit and intended to use this function in the validation of data, in order to inform the user if the number was not valid, since the function returns a boolean value.
For example in cell A1, I create a custom data validation and place = verificaNIF (A1), but I get an error stating:
Cannot find a range with the name you specified
There is no problem in userform or Vba, but this cell validation must be included in cells.
What am I doing incorrect?
Thanks
Hi,
have a function VBA that verifies the Portuguese TIN is valid (Como validar um NIF no Excel - www.JJoao.com) through the control digit and intended to use this function in the validation of data, in order to inform the user if the number was not valid, since the function returns a boolean value.
For example in cell A1, I create a custom data validation and place = verificaNIF (A1), but I get an error stating:
Cannot find a range with the name you specified
There is no problem in userform or Vba, but this cell validation must be included in cells.
What am I doing incorrect?
Thanks