Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 182347 - Last Review: January 22, 2007 - Revision: 2.3
OFF97: Selected Check Box or Option Button Prints Unselected
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
UserForm object
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.
APPLIES TO
- Microsoft Excel 97 Standard Edition
- Microsoft PowerPoint 97 Standard Edition
- Microsoft Word 97 Standard Edition
- Microsoft Windows 95
- Microsoft Office 97 Standard Edition
| kbbug kbpending kbprint KB182347 |
Retired KB Content DisclaimerThis article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate
Be the first to leave feedback, to help others about this knowledge base
article.
(Optional) Name
(Optional)
Public URL Or Email
Comments
No
HTML -- Text Only Please