VBA: Selected Check Box or Option Button Prints Unselected

• Microsoft Excel 97 for Windows
• Microsoft PowerPoint 97 for Windows
• Microsoft Word 97 for Windows
• Microsoft Windows 95
• Microsoft Visual Basic for Applications version 5.0

SYMPTOMS

When you print a UserForm, check boxes and option buttons that are selected print as if they are not selected. For example, if a CheckBox control on a UserForm has a check in it (the Value property of the CheckBox control is set to TRUE), the CheckBox control prints without a check in it.

NOTE: This behavior does not occur on Microsoft Windows NT.

WORKAROUND

To work around this issue, create an image of the UserForm by using screen capture, and print this image. For example, to create a screen capture in Microsoft Excel 97, follow these steps:

1. Start Microsoft Excel 97.

2. Press ALT+F11 to start the Visual Basic Editor.

3. On the Insert menu, click UserForm. Draw a CheckBox and a CommandButton control on the UserForm.

4. With the UserForm selected, press F5 to run the UserForm. Click to select (place a check) in the CheckBox.

5. Press ALT+PRINT SCREEN. This copies an image of the UserForm to the clipboard.

6. On the Edit menu, click Paste. The image of the UserForm is pasted into the worksheet.

7. Click Print on the File menu to print the UserForm.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.

       CommandButton. The UserForm is printed.

REFERENCES

For more information about UserForms, from the Visual Basic Editor, click Contents And Index on the Help menu, click the Index tab in Microsoft Excel Help, and type the following text

   UserForm object