neosegauk
05-31-2014, 10:44 AM
Hope you are all doing well. I have a few questions (please bare with me as I am new to VBA). I am tring to get an excel user form to validate the cells that are not protected. What I am looking to do is make sure each field has over 3 charecters of text. Once these are validated then the user can hit a send button (which will only become active when all fields are completed) and then it to sends an email with the spreadsheet (userform) attached.
I am unsure how to go about doing this. What would be the best steps to take?
Please see the form https://docs.google.com/file/d/0B8OtUevU1V5sWlc2RDF4T0p6Qzg/edit (this opens in Google drive but can be downloaded by pressing File and download to view what I have done. Including send buton).
(hope this makes sense, if not I am happy to answer any questions)
Thanks.
I am unsure how to go about doing this. What would be the best steps to take?
Please see the form https://docs.google.com/file/d/0B8OtUevU1V5sWlc2RDF4T0p6Qzg/edit (this opens in Google drive but can be downloaded by pressing File and download to view what I have done. Including send buton).
(hope this makes sense, if not I am happy to answer any questions)
Thanks.