Case Study Bug Adding Controls to an Existing Form

If you have a userform that you've been using for some time and later try to add a new control,you might find that Excel seems to get confused about the control.You will see that the control is added to the form, but when you right-click the control and choose View Code, the code module does not seem to acknowledge that the control exists. The control name will not be available in the left drop-down at the top of the code module.

To work around this situation,follow these steps:

1. Add all the controls you need to add to the existing form.

2. In the project explorer, right-click the userform and choose Export File. Choose Save to save the file in the default location.

0 0

Post a comment