UserForm Placement over Chart.

chajnik · August 27th, 2004, 07:09 AM

Hi!
Has anyone an idea to the following:
In Excel I have a chart (located as a Sheet).
How can I place a (small) UserForm either in the top left corner of the ChartArea or preferrably in the top left corner of the area containing the ChartArea (i.e. just under the toolbars). That is how do I calculate a top + left position for it?
Thanks in advance!

BrianB · September 9th, 2004, 07:41 AM

Don't know the exact answer. The variations of Top & Left are too numerous to mention here. I suggest that you look them up in VB Editor Help. Type Top in a module and hit F1 key. Might be something like this :-

Code:

UserForm1.Top = Worksheets("Sheet1").ChartObjects(1).Top

-----------------------
Regards BrianB
Most problems occur from starting at the wrong place.
Use a cup of coffee to make Windows run faster.
It is easy until you know how.