Microsoft Office Tutorials and References
In Depth Information
Chapter 15: Advanced UserForm Techniques
Following are a few points to help you understand how this example works:
h The UserForm is displayed modeless so that you can still access the worksheet while it’s
h Code at the top of the procedure checks to make sure that the active sheet is a
worksheet. If the sheet isn’t a worksheet, the Label controls are assigned the text N/A .
h The workbook monitors the active cell by using a Selection_Change event (which is
located in the ThisWorkbook code module).
h The information is displayed in Label controls on the UserForm.
Figure 15-2 shows a more sophisticated version of this example. This version displays quite a bit
of additional information about the selected cell. Long-time Excel users might notice the
similarity to the Info window — a handy feature that was removed from Excel several versions ago. The
code is too lengthy to display here, but you can view the well-commented code in the example
Figure 15-2: This modeless UserForm displays various information about the active cell.
This example, named modeless userform2.xlsm , is available on the companion