Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 290
Default Label with Scroll Bars

Hi All,

Is it possible to scroll up and down a label, and I cant use a textbox
it has to be a label.

If there isnt a scroll bar property for a label then does anyone know
of a workaround so that I can wee all of the text in a lable if it is
more lines that can be seen (and I cannot resize the label to fit the
text)

Any help much appreciated.

Duncan

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6,953
Default Label with Scroll Bars

You could use a spinbutton control and control the display of text perhaps.
but I would beg to differ that you can't use a textbox. You can configure a
textbox to behave almost exactly as a label including appearance - if you
lock with the locked property, it can't be edited (if that is your concern).


--
Regards,
Tom Ogilvy


"Duncan" wrote:

Hi All,

Is it possible to scroll up and down a label, and I cant use a textbox
it has to be a label.

If there isnt a scroll bar property for a label then does anyone know
of a workaround so that I can wee all of the text in a lable if it is
more lines that can be seen (and I cannot resize the label to fit the
text)

Any help much appreciated.

Duncan


  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 290
Default Label with Scroll Bars

Hi Tom,

Thank you for this, completely agree with the textbox workaround, just
wondered if it was possible to add the scroll property to a label, I
like the spin button idea and will play about with that.

Many thanks

Duncan


Tom Ogilvy wrote:
You could use a spinbutton control and control the display of text perhaps.
but I would beg to differ that you can't use a textbox. You can configure a
textbox to behave almost exactly as a label including appearance - if you
lock with the locked property, it can't be edited (if that is your concern).


--
Regards,
Tom Ogilvy


"Duncan" wrote:

Hi All,

Is it possible to scroll up and down a label, and I cant use a textbox
it has to be a label.

If there isnt a scroll bar property for a label then does anyone know
of a workaround so that I can wee all of the text in a lable if it is
more lines that can be seen (and I cannot resize the label to fit the
text)

Any help much appreciated.

Duncan



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
scroll bars Cutearmychic Excel Worksheet Functions 1 August 22nd 08 08:53 PM
SCROLL BARS GSB Excel Discussion (Misc queries) 1 September 28th 07 05:03 PM
Scroll bars Tazzy via OfficeKB.com Excel Discussion (Misc queries) 3 December 10th 06 10:28 PM
scroll bars vqthomf Excel Programming 1 February 6th 06 12:11 PM
Scroll bars Embalmer Excel Discussion (Misc queries) 1 December 31st 05 05:05 PM


All times are GMT +1. The time now is 09:45 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"