Thread: Form Position
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
steven steven is offline
external usenet poster
 
Posts: 389
Default Form Position

Héctor,

Thank you for the response. I tried the download file and it gives me an
error in this section at the : VCmdArr(.RowIndex) = .Height ; it says
subscript out of range for the VCmdArr(.RowIndex). What is causing this?

For Each CmdBar In Application.CommandBars
With CmdBar
If (.Visible = True) And (.Position = msoBarTop) Or (.Position =
msoBarMenuBar) Then
If .RowIndex 0 Then
VCmdArr(.RowIndex) = .Height
End If
End If
If (.Visible = True) And (.Position = msoBarLeft) Then
If .RowIndex 0 Then
HCmdArr(.RowIndex) = .Width
End If
End If
End With
Next CmdBar


Thank you,


Steven

"Héctor Miguel" wrote:

hi, Steven !

Is there a way to make a form open where the top left corner of the form
will be the one cell to the right and one cell down from the active cell...


all you need is Chip's Form Positioner
http://www.cpearson.com/Excel/FormPosition.htm

regards,
hector.