nikki333
08-03-2018, 01:12 PM
Hi Folks
I'm trying to write a data validation rule via VBA.
The purpose should be to check whether a certain value/text is present in one cell of row (let's say X), and if so then to allow only "x" or "" for the rest of that row.
My try for the formula in the data verification goes as follows:
=IF(B$4 = "Standard"; OR("x";""))
(the logik should be like: if cell B4="Standard" then allowed values are either "x" or ""
Many thanks,
Cheerio
I'm trying to write a data validation rule via VBA.
The purpose should be to check whether a certain value/text is present in one cell of row (let's say X), and if so then to allow only "x" or "" for the rest of that row.
My try for the formula in the data verification goes as follows:
=IF(B$4 = "Standard"; OR("x";""))
(the logik should be like: if cell B4="Standard" then allowed values are either "x" or ""
Many thanks,
Cheerio