Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Excel VBA > Excel VBA
|
Excel VBA Discuss using VBA for Excel programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Excel VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old August 27th, 2004, 07:09 AM
Registered User
 
Join Date: Aug 2004
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default UserForm Placement over Chart.

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!


 
Old September 9th, 2004, 07:41 AM
Authorized User
 
Join Date: Aug 2004
Posts: 54
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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.





Similar Threads
Thread Thread Starter Forum Replies Last Post
Chapter 6: Page 197 - CSS placement VeganMan BOOK: Beginning ASP.NET 3.5 : in C# and VB BOOK ISBN: 978-0-470-18759-3 11 April 7th, 2008 01:43 PM
2 small problems, maybe movenext placement? aduggan Classic ASP Databases 1 April 24th, 2007 12:28 PM
Post Preview Window Placement SerranoG Forum and Wrox.com Feedback 1 June 13th, 2003 09:26 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.