OFF97: Selected Check Box or Option Button Prints Unselected (182347)
The information in this article applies to:
- Microsoft Excel 97 for Windows
- Microsoft PowerPoint 97 for Windows
- Microsoft Word 97 for Windows
- the operating system: Microsoft Windows 95
- Microsoft Office 97 for Windows
This article was previously published under Q182347 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:
- Start Microsoft Excel 97.
- Press ALT+F11 to start the Visual Basic Editor.
- On the Insert menu, click UserForm. Draw a CheckBox and a CommandButton
control on the UserForm.
- With the UserForm selected, press F5 to run the UserForm. Click to
select (place a check) in the CheckBox.
- Press ALT+PRINT SCREEN. This copies an image of the UserForm to the
clipboard.
- On the Edit menu, click Paste. The image of the UserForm is pasted
into the worksheet.
- 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.
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
and then double-click the selected text to go to the "UserForm object"
topic. If you are unable to find the information you need, ask the Office
Assistant.
| Modification Type: | Minor | Last Reviewed: | 9/13/2006 |
|---|
| Keywords: | kbbug kbpending kbprint KB182347 |
|---|
|