Hi
I am a novice to VBA. I followed a video to create a userform to do data entry. This is supposed to lead to some analysis later. The problem is that text boxes and combo boxes are generating their own input - garbage.
I have no idea why this happens since the data is validated. The following were corrupted:
Last Name, PCA Level of Service, Service Coordinator and Informal Contact Support Status. The data was changed to 1677215
I've uploaded the file with the code
In your ValidEntry function you have code like this:
.txtLastName.Text = vbWhite
which will put the value of the vbWhite constant (which is 1677215) in the specified control. You have several instances of this.
Thank you very,very much.
I totally overlooked that part.
Blessings!