Important This article contains information about how to modify the registry. Make sure to back up the registry before you modify it. Make sure that you know how to restore the registry if a problem occurs. For more information about how to back up, restore, and modify the registry, click the following article number to view the article in the Microsoft Knowledge Base:

Symptoms

When you use a RefEdit control in a user form, you cannot use keyboard shortcuts, such as CTRL+SHIFT+END, to enter a range in the RefEdit control.

Additionally, if you launch the Chart Wizard or the PivotTable Wizard from the popup menu, when you hold down CTRL+ARROW key to select a range in the PivotTable Wizard or in the Chart Wizard, the shortcut key does not work correctly.

Workaround

Fix it for me

To fix this problem automatically, click the Fix itbutton or link. Click Runin the File Downloaddialog box, and follow the steps in the Fix it wizard.

Notes

You must have Microsoft Office 2000 Service Pack 3 or later versions installed to run the Fix it solution for Microsoft Office 2000.

You must have Microsoft Office 2002 Service Pack 2 or later versions installed to run the Fix it solution for Microsoft Office 2002.

This wizard may be in English only; however, the automatic fix also works for other language versions of Windows.

If you are not on the computer that has the problem, save the Fix it solution to a flash drive or a CD and then run it on the computer that has the problem.

Let me fix it myself

To work around this issue, use one of the following methods:

Method 1: Add the registry key

Important This section, method, or task contains steps that tell you how to modify the registry. However, serious problems might occur if you modify the registry incorrectly. Therefore, make sure that you follow these steps carefully. For added protection, back up the registry before you modify it. Then, you can restore the registry if a problem occurs. For more information about how to back up and restore the registry, click the following article number to view the article in the Microsoft Knowledge Base: