Notifications
Clear all
VBA & Macros
3
Posts
2
Users
0
Reactions
103
Views
Topic starter
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
Posted : 17/03/2020 10:19 am
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.
Posted : 17/03/2020 3:37 pm
Topic starter
Thank you very,very much.
I totally overlooked that part.
Blessings!
Posted : 17/03/2020 7:38 pm
