Validating user input in excel vba


11-Nov-2018 19:30

In the loan amortization worksheet, you would like to restrict the values that a loan origination officer can enter when creating the amortization schedule.More specifically, you would like to insert the following rules: To ensure the worksheet meets the three rules outlined above, begin by selecting cell D4 and clicking Data Validation on the Data tab of the Ribbon to open the Data Validation rule dialog box pictured in Figure 2.Do I have to write code for EVERY textbox to check if it's numeric data if it's supposed to be? The amount of code that I'm writing seems to be getting out of hand. Currently I have a number of routines like this: 'check for valid dates If Not Is Date(txt Purch Dt) Then Purch Dt.

For example, you might populate the fields for the Input Message, as shown in Figure 4.

What would your recommendation be for an alternative to doing a similar action for each of the input boxes private subs?

That is A LOT of repetiion and risk for missing an update.

This video explains how to loop over the controls collection to check if every textbox has been completed.

You can download any files that you need to follow the video here.You can improve the resolution of the video using another icon at the bottom right of the frame.This will slow down the connection speed, but increase the display and sound quality.I'll continue to do some research on my end, but if you have any further insight, I'd appreciate it. As it stands:"Do I have to write code for EVERY textbox to check if it's numeric data if it's supposed to be?