![]() ![]() Strictly speaking a Userform is a user-defined data type. The first 11 steps create the definition of frmCustomMsgbox, which is a "pattern" for a Userform. Now simply run your procedure again an take advantage of the enhance look and functioanilty provided by the Userform. MyForm.Caption = oWord & " starts with ""Z""" With a Userform you can have the look, layout, and options tailored to your specific need: With a standard VBA message box, you have to cheat and use descriptive explanatory message text to make alternative options even workable. The author of the code clearly understands that the user may tire of processing each word one by one and wants to offer the ability to get on with it and auto process any remaining words that start with "z."Īs you can see "Yes, No, Cancel" or the other combinations available don't really lend themselves to the desired options. & " popup." & vbCr & "and AutoDelete all words that" _ & vbCr & vbCr & "Press ""Cancel"" to suppress this" _ ![]() Select Case MsgBox("Delete this word: Yes/No?" _
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |