Tab Strips and Multi Page Controls

Thu, 27 Jun 2019 | Office 2007 VBA | 2 comments
Excel Vba Refedit Multipage Userform

I mentioned earlier that you can use frames to group related controls visually and help the user make sense of the form. However, there are two situations in which a frame falls down on the job. The first situation is when you need the form to show multiple sets of the same or similar data. For example, suppose you have a form that shows values for sales and expense categories. You might want the form to be capable of showing separate data for various company divisions. One solution would be to...

Accessing an Applications Builtin Dialog Boxes

Fri, 19 Aug 2016 | Office 2007 VBA

Many VBA methods are known as dialog box equivalents because they let you select the same options that are available in an application's built-in dialog boxes. Using dialog box equivalents works fine if your procedure knows which options to select, but there are times when you might want the user to specify some of the dialog box options. For example, if your procedure prints a document (using the Application object's Printout method), you might need to know how many copies the user wants or...