ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Duplicated code window and userform window problem (https://www.excelbanter.com/excel-programming/376877-duplicated-code-window-userform-window-problem.html)

Zhu

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


Jay

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


Zhu

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


NickHK

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