Prev: Cleanup remnants
Next: Error 32765
From: R Vaughn on 8 Aug 2010 17:21
In Excel 2003, I am attempting to automatically place a VBA form on a
worksheet at a constant position relative to the worksheet, not at a constant
position on the screen. I want the code to identify the worksheet's
position, then use the information to assign the corrent coordinates for the
form.

I tried "Activesheet", "ActiveWindow", "VisibleRange", etc, but haven't
found the right combination. I am sure that there is a straightforward
solution for this (a simple command or statement?) but but I haven't found it
yet.
From: Nobody on 8 Aug 2010 18:08
"R Vaughn" <RVaughn(a)discussions.microsoft.com> wrote in message
news:0B8B9778-5B7E-4E94-99FC-7126271B94C1(a)microsoft.com...
> In Excel 2003, I am attempting to automatically place a VBA form on a
> worksheet at a constant position relative to the worksheet, not at a
> constant
> position on the screen. I want the code to identify the worksheet's
> position, then use the information to assign the corrent coordinates for
> the
> form.

This group is for the stand alone product Visual Basic 6 or lower. For VBA,
try one of these groups:

news://news.aioe.org/microsoft.public.office.developer.vba
news://news.aioe.org/microsoft.public.excel.programming
news://news.aioe.org/microsoft.public.access.modulescoding
news://news.aioe.org/microsoft.public.word.vba.general
news://news.aioe.org/microsoft.public.outlook.program_vba
news://news.aioe.org/microsoft.public.office.developer.outlook.vba
news://news.aioe.org/microsoft.public.powerpoint



 | 
Pages: 1
Prev: Cleanup remnants
Next: Error 32765