Form Validation and Insert Object Questions

Hi there fellas,

I'm not that versed in excel let alone VBA, but I usually search for what I need (formulas and macros) and get it done, as most of the stuff I do in excel is rather simple. I've been searching online for a couple of hours now but I couldn't find what I need.

I pretty much need a validation message for a form (plenty of info and videos on this) however I'm not using the "Form" command - which I believe is mostly used for data entry, I created text boxes and a couple of buttons as this will be a unique form completed once by the person that receives it.

1. With that said need a macro that generates a single message if any of the text boxes is empty and to color which ones are empty
2. I also need a macro to attach documents into excel (pdf, jpg, etc.) I got one on the file I attached that worked to browse files but other users cant open the objects. Having the objects on a particular cell instead of the active cell would be ideal. If this is complicated maybe a button that attach embedded documents (using the macro I already got) along with the excel form into an email could do the trick. The embed file question has been solved.

Edit: wording to make it easier to understand.

Thanks in advance for the support and sorry if I'm asking for too much!

Hi Cristian,

Thanks for bumping it, life got in the way and it slipped my mind to come back to your thread (apologies)!

I'll take some time by tomorrow to send what I think should be a fix for your validation problem, but I wanted to ask about your 2nd part:

I also need a macro to attach documents into excel (pdf, jpg, etc.) I got one on the file I attached that worked to browse files but other users cant open the objects. Having the objects on a particular cell instead of the active cell would be ideal. If this is complicated maybe a button that attach embedded documents (using the macro I already got) along with the excel form into an email could do the trick.

Your macro to attach objects seems to work fine to me...it puts them in random places all over, but I was able to open the 2 I test-attached as well as the one you had attached before uploading your document (the PDF invoice for Service Cloud Lightning CRM -Unlimited ...). They might not have been able to open them because design mode was active in the version you attached (not sure).

For future reference, you might consider using a user form (much easier for validation purposes), but Ill get back to you soon with an attempt.

Hey man! I really appreciate the time! while this works, I found it generates tons of messages, I'd prefer something that generates a single message if any of the text boxes is empty and to color which ones are empty, does that make sense?

Originally Posted by liquidmettle

For future reference, you might consider using a user form (much easier for validation purposes), but Ill get back to you soon with an attempt.

I was wondering what are your thoughts on this, everything I found on forms were more for data entry instead of a document that needs to be completed a single time (does that make sense?) i.e https://www.youtube.com/watch?v=cNpFB8M1-dI&t= but I wanted something that "looked" more professional.

Also, I like the changes you made, it does looks better!