User Forms

[Ann]

I have created a user form and it works fine on my pc
which is on 2000 but when I open this on someone else's pc
the form will not maximise and you can see the rest of the
screen behind??

Also, I have Comments attached to some cells but when I
rest the mouse pointer over the cells it is partially
disappearing off the screen - is it possible to move these
comments boxes so that they show elsewhere on the screen
and are not missing half the text??

Thanks

Ann

 

[Mike]

Common posting practise: One question per post please.

It's likely that you are using a lower resolution than the
other person. User forms don't have maximize, minimize
capabilities, so they are normally kept small. You
suggest that you want to cover the entire screen but that
is not advisable. I hate applications that do that, and
many other people would agree with me, but this will set
your user form to take the same space as Excel. The
problem with this kind of thing is that you'll also need
to resize/locate the controls on your form.

With frmYourForm
.Top = 1
.Left = 1
.Width = Application.Width
.Height = Application.Height
End With

If your comment is in the last visible column on the
right, or if you have Freeze Panes set, you may loose part
of the comment. There is nothing you can do about that
except scroll over a bit. You could try using a Data
Validation Message (from the menu select Data/Validation,
click the Input Message tab and enter a comment). These
pop up underneath the selected the cell, not when you move
the mouse pointer, but they will always be 100% visible
even if you scroll away from the selected cell. And they
take up less memory too.