How to allow only input of numerical values in userform text-box using Excel VBA
163 بار بازدید -
6 سال پیش
-
How can we prevent users
How can we prevent users to avoid errors while entering data into a User Form in MS Excel? Often we need to enter only numerical values for the price of an item in a text-box on a user-form. We can achieve this by using Excel VBA.
Since the data entry happens on 'key press' we use this feature to capture any invalid entries like alpha values. Each key-stroke or key-press is assigned a numerical value in the American standard Code for Information Interchange or ASCII. Wikipedia describes ASCII as: The Americ
6 سال پیش
در تاریخ 1396/12/09 منتشر شده
است.
163
بـار بازدید شده