ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   allow entry in only one txtbox (https://www.excelbanter.com/excel-programming/379360-allow-entry-only-one-txtbox.html)

CR[_2_]

allow entry in only one txtbox
 
I have a userform with 5 frames. Each frame has 2 txtboxes and 2 labels.
The user needs to enter a numeric value in one of the txtboxes but not both.

How to code the form to loop through the frames and check that only one in
each frame has an entry and then give a msgbox when the save button is
pushed?

Thank You
CR




All times are GMT +1. The time now is 10:04 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com