Build a Msgbox generator tool

[ipbr21054]

Hi,
Photo supplied for an example of what im going to try & make as im having plenty of issues remembering the correct syntax for the MsgBox

My plan is to Write in a Texbox the Title, Textbox for the message & click an image for the Yes / No options.
As this is being created im looking to have the syntax appear in a Listbox etc of whioch clicking a button will copy the line of code so i can apply straight into my worksheet.

Yes it might be easier for some people to just learn the correct process & not do what ive mentioned but my learning issues are different everyday & more often than not im forgetting things.

Is it possibel with some help from this group to do my tool.

Thanks

 

[rlv01]

The MZTools package has something similar:

I like your 'generated code' pane though, and the fact that your preview pane is always visible. Good luck with your project.

 

[ipbr21054]

So to get my started i have the following.

The syntax shown produces the Msgbox as supplied.

MsgBox ("TextBox1.Value"), vbOKCancel + vbCritical, "TextBox2.Value"

How would the above be written correctly so whatever is in TextBox1 & TextBox2 on my userform then populate the line of code to produce my msgbox, same for Buttons etc

This should keep me busy for a while