Valiad Data in Spread

Posted by: zxx2403 on 8 September 2017, 12:41 pm EST

  • Posted 8 September 2017, 12:41 pm EST

    My problem is that


    for Example


    the value cell(3,5) is number ,But If user Input alpha,I give a messagbox "You Must Input Number"


    I want user leave the cell ,util The Input is valiad .


    It mean the input must number


    else


         not continue


    What I can do


                               thanks a lot

  • Replied 8 September 2017, 12:41 pm EST

    Hello,


    In the LeaveCell event you can check the cell you are leaving to see if it is valid. If it is not, then set the e.Cancel parameter to True to keep the user from being able to leave the cell.

  • Replied 8 September 2017, 12:41 pm EST

    thank you very much


     

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels