Hello,
im the basic excel user. i have been encountered with the issue where i have to check whether a particular value is present in the cell and prompt the user accordingly..
a1 b1 c1 d1 e1 f1 g1 ............
X DE Z DE L DE M........
-
-
-
-
-
-
-
-
X DE Z DE L DE M........
this is how my entry will look....
The thing i have to validate is if B1 or D1 or any of the column .has the value DE already it should prompt the error message as "DE already exist" when i enter the value as DE in F1..
i can't do this by creating Master formulae as the ROW count increases more than 1000.Configuration: Windows XP
Internet Explorer 6.0
Check each cell in column for criteria Check the cell format is date Check whether formula value changes Excel if cell equals retrieve cell value Excel macro get cell value from other file Excel search for cell value return cell reference Excel select from multiple cell values Excel set cell value Excel vba check if cell is selected Excel vba file check if cell value exists Fill background color excel cell value Google spreadsheet change color according to cell value How do i find cell value in spreadsheet with vba How to colour if cell value is number using macros How to compare a cell value with multiple values and return the matched values in excel Vba excel group if cell value Vba fill text box with cell value Xls vba combine multiple row values to single cell