This topic has been archived. It cannot be replied.
-
工作学习 / 专业技术讨论 / Help Please!!! Excel validationwhen user enter data into a cell, the data shouldn't inlcude one letter "A". If the user enter "U", the system will pop uo a warning box to remind the user it is wrong. How can do it? Help me please!!! Thank you a lots.
-raindot(如是);
2005-12-9
{224}
(#2653365@0)
-
Menu: Data->Validation->Settings->Allow->Custom->Formula->
=ISERROR(FIND("A",A1)) or ISERROR(FIND("U",A1))
-schen(睹往睹来.非赌徒也!);
2005-12-9
(#2653658@0)
-
Thank you so much. It works!!!! Have a great weekend!!!
-raindot(如是);
2005-12-9
(#2653671@0)
-
More than one validation for a cellHi there, I am really a Excel beginner. In last case, I need to add another data validation for the same cell. And when any one condition happens, the system should pop up the corresponding alert message. Do I have to do some programming or just use formular to implement it? Please Help!!! I own you a dinner.
-raindot(如是);
2005-12-13
{310}
(#2660434@0)
-
It depends on how complex the validation is. If it's simple then you just need to modify the first formula (combine them using AND). Next time post your validationrequirement so other people can help as well. Owe me a dinner? well I am in Vancouver so if you ever get a chance to Vancouver let me know :)
-schen(睹往睹来.非赌徒也!);
2005-12-13
{141}
(#2660915@0)
-
Thanks a lot. I have combined three validation used AND. My issue is the system should display different alert message according to different validation. Then the user can know where he is wrong.
-raindot(如是);
2005-12-13
(#2660972@0)
-
In that case, using VBA macro will be easier.. If you want you can send me the validation rules and I'll code you a sample.Have you done any coding before?
-schen(睹往睹来.非赌徒也!);
2005-12-13
{32}
(#2661021@0)
-
pls check your PM
-raindot(如是);
2005-12-13
(#2661081@0)
-
solution sent to your PM
-schen(睹往睹来.非赌徒也!);
2005-12-13
(#2661410@0)
-
Thank you a lot. One more issue. After the alert message box displays, can it be like the Data validation, the current cell is Highlight and user has to correct the input after move to another cell?
-raindot(如是);
2005-12-14
(#2662489@0)
-
Never mind. I figured it out. Anyway, thank you very much.
-raindot(如是);
2005-12-14
(#2662543@0)