Creating and error Message Userform

Originally Posted by fredlo2010

I am trying to create an userform that will act as an error display. The reason why I want to use the form and not a regular MsgBox is because I want to include a very simple small tutorial of what went wrong.

I admire your ambition. There are a lot of VBA error descriptions out there - you are going to write a tutorial for all of them?!

Originally Posted by fredlo2010

My form should have.
1. An icon to make very clear that the operation that was attempted failed. (vbwarning)
2. Sound if possible.
3. It will have a small description of the issue and below a picture with the correct settings. This causes an issue. I will be using about three pictures but they have to be big enough so the user can see them. How can I arrange items in a relatively small userform with a scroll bar on the side?

1 = should be no problem.
2 = I may be wrong on this - but I think VBA can only play a beep sound (just type beep in a sub line). (Unless there is a way to have the sound played by an outside application like Windows Media Player?)
3 = It's hard to help out this without seeing some idea of what you want your form to look like. Would you be able to dummy up a sample form and upload it in a workbook to this thread?

BTW I'm unclear as to whether you only require assistance with the design the form or whether you need the code as well. Do you have any error code completed/in progress?

It looks to me like goals 2 & 3 are already achieved. Correct me if I am wrong but you only require the warning icon now, right?

Also:

• Do you intend to write an error tutorial for every possible VBA error?! Or just the 'data was not imported correctly and the pivot tables cannot refresh properly'?
• If the latter, do you have the Err.Numbers for these two issues? (So that the ErrorForm only shows when these errors appear - as opposed to showing when any VBA error occurs)