View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.programming
Peter T Peter T is offline
external usenet poster
 
Posts: 5,600
Default Can anyone help me with Scrollbars please?

FYI the OP posted feedback about the Label in a Frame approach in another
thread (last message in this link).

http://groups.google.co.uk/group/mic...06336ba7114fb7

Regards,
Peter T


"elbeardo69" wrote in message
...
I've just pondered this one.

My easy but dirty hack, a dummy textbox of size 0x0 anywhere.. ..then
.Activate it to send the annoying cursor elsewhere.

Anybody know how to highlight all the text AND set the first line in

focus?
..I suppose I could just do the colour inverting myself...

"Peter T" wrote:

Another idea, put an ordinary Label in a Frame.
Give the frame a vertical scrollbar and size the frame to suit.

Optionally
remove the Frame's caption, set Frame's BorderStyle=1, remove the

Label's
border.

Manually or at run time set the ScrollHeight to Label's height (or tweak

as
required).

Regards,
Peter T

PS, ensure the Label really is IN the Frame and not merely over it.

"kirkm" wrote in message
...

Thanks. I want a verticle scrollbar on a label.
That may not be allowed.... but if it goes on the Form,
how it is controlled?

Thanks - Kirk