Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
View cell contents as a pop-up window (similar to comments window) | Excel Worksheet Functions | |||
VBA line of code executes in Immediate Window but not in Code Window | Excel Discussion (Misc queries) | |||
Docking Project Explorer, Properties window and Code window in VBE | Setting up and Configuration of Excel | |||
The window opens in a smaller window not full sized window. | Excel Discussion (Misc queries) | |||
Immediate Window not showing up below code window | Excel Programming |