![]() |
Duplicated code window and userform window problem
Initially, the Project Explorer and Property window can not be docked to the
left side in the VBE. I have them fixed by deleting the code in the Registery Editor by running Regiedit. But here are still some other problems: I have duplicated Code Windows. Each time when I click a Module, a new Code Window appears. But I just need one. Also, the Userform design window can not be resized togather with the userform. Can anybody tell me how to fix the problems? Thanks |
Duplicated code window and userform window problem
Hi Zhu -
I think what you're describing is normal. Each module uses its own work area window. If you want all VB procedure code in one window, copy all the code to one module. As for the UserForm design Window, you can't move the left or upper edges of the form itself (they're locked to the work area window), but you can drag the right-hand and lower edges of the form, essentially giving you total control over its size. I don't think your work area is broken; unless I've misunderstood you, that's the way it's supposed to work. -- Jay "Zhu" wrote: Initially, the Project Explorer and Property window can not be docked to the left side in the VBE. I have them fixed by deleting the code in the Registery Editor by running Regiedit. But here are still some other problems: I have duplicated Code Windows. Each time when I click a Module, a new Code Window appears. But I just need one. Also, the Userform design window can not be resized togather with the userform. Can anybody tell me how to fix the problems? Thanks |
Duplicated code window and userform window problem
Thank you so much, Jay:
1)Project Explorer: objects under the VBAproject used to be in a tree view, grouped by worksheets, forms, modules and class modules. But now the tree view is gone, and all objects are are listed togather with alphabetic order. It is difficult to tell which is what now. 2)Code Window: There used to be only one code window shown. But now so many code windows are shown, and they overlap each other. I have to search and make front the window I need to work. 3)Userform Window: Now I can drag the edge of the userform's work area and make the work area smaller than the userform, that is to say, half of the userform can be shadowed by its work area. But before the problem happened, the userform was resized when I drag the edge of its work area, and the userform could not be shadowed by the window it resided. Zhu "Jay" wrote: Hi Zhu - I think what you're describing is normal. Each module uses its own work area window. If you want all VB procedure code in one window, copy all the code to one module. As for the UserForm design Window, you can't move the left or upper edges of the form itself (they're locked to the work area window), but you can drag the right-hand and lower edges of the form, essentially giving you total control over its size. I don't think your work area is broken; unless I've misunderstood you, that's the way it's supposed to work. -- Jay "Zhu" wrote: Initially, the Project Explorer and Property window can not be docked to the left side in the VBE. I have them fixed by deleting the code in the Registery Editor by running Regiedit. But here are still some other problems: I have duplicated Code Windows. Each time when I click a Module, a new Code Window appears. But I just need one. Also, the Userform design window can not be resized togather with the userform. Can anybody tell me how to fix the problems? Thanks |
Duplicated code window and userform window problem
1 - At the top of the Projects window, click the folder icon that has a Tool
tip of "Toggle Folders". 2 - You have all those code windows open. Close each normally. 3 - AFAIK, that is normal behaviour. There is no relationship between the size of the userform and the size its window. NickHK "Zhu" wrote in message ... Thank you so much, Jay: 1)Project Explorer: objects under the VBAproject used to be in a tree view, grouped by worksheets, forms, modules and class modules. But now the tree view is gone, and all objects are are listed togather with alphabetic order. It is difficult to tell which is what now. 2)Code Window: There used to be only one code window shown. But now so many code windows are shown, and they overlap each other. I have to search and make front the window I need to work. 3)Userform Window: Now I can drag the edge of the userform's work area and make the work area smaller than the userform, that is to say, half of the userform can be shadowed by its work area. But before the problem happened, the userform was resized when I drag the edge of its work area, and the userform could not be shadowed by the window it resided. Zhu "Jay" wrote: Hi Zhu - I think what you're describing is normal. Each module uses its own work area window. If you want all VB procedure code in one window, copy all the code to one module. As for the UserForm design Window, you can't move the left or upper edges of the form itself (they're locked to the work area window), but you can drag the right-hand and lower edges of the form, essentially giving you total control over its size. I don't think your work area is broken; unless I've misunderstood you, that's the way it's supposed to work. -- Jay "Zhu" wrote: Initially, the Project Explorer and Property window can not be docked to the left side in the VBE. I have them fixed by deleting the code in the Registery Editor by running Regiedit. But here are still some other problems: I have duplicated Code Windows. Each time when I click a Module, a new Code Window appears. But I just need one. Also, the Userform design window can not be resized togather with the userform. Can anybody tell me how to fix the problems? Thanks |
All times are GMT +1. The time now is 03:04 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com