ashgull80
10-21-2016, 04:19 AM
Hi
Im sure ive seen alot of people do this but i am a complete noivce with vba so not sure where to start.
my issues are that i have a userform that i use to input data to a sheet.
firstly i pick a job number from a database sheet either from a dropdown box or typing into the dropdown box, if i type in the dropdown box and i accidently type a number that is not on the database list i get a 'runtime error 91'
secondly i have a textbox that i input a date into, likewise if im typing a date and i input it incorrectly i get a 'runtime error 13' type mismatch.
i completly uinderstand why these errors occur but what i would like to do is instead of the error function i would like a small error message that pops up but can then be closed to rectify the issue rater than having the error handling box pop up and then ending so the userform unloads and need to start from the beginning.
I hope that all makes sense and i lookforward to some help/advice.
thanks ash
Im sure ive seen alot of people do this but i am a complete noivce with vba so not sure where to start.
my issues are that i have a userform that i use to input data to a sheet.
firstly i pick a job number from a database sheet either from a dropdown box or typing into the dropdown box, if i type in the dropdown box and i accidently type a number that is not on the database list i get a 'runtime error 91'
secondly i have a textbox that i input a date into, likewise if im typing a date and i input it incorrectly i get a 'runtime error 13' type mismatch.
i completly uinderstand why these errors occur but what i would like to do is instead of the error function i would like a small error message that pops up but can then be closed to rectify the issue rater than having the error handling box pop up and then ending so the userform unloads and need to start from the beginning.
I hope that all makes sense and i lookforward to some help/advice.
thanks ash