Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can anyone help me with Scrollbars please?
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can anyone help me with Scrollbars please?
You can't add scrollbars to a label; however, if I understand why you are
asking this question correctly, you can use a TextBox and set its Lock property to True to prevent users from being able to change the text in it. Rick "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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can anyone help me with Scrollbars please?
On Sun, 2 Mar 2008 19:39:03 -0500, "Rick Rothstein \(MVP - VB\)"
wrote: You can't add scrollbars to a label; however, if I understand why you are asking this question correctly, you can use a TextBox and set its Lock property to True to prevent users from being able to change the text in it. Hi Rick, that's almost got everything I was after. Except the one thing that stuffs it up. How do I turn the cursor off? Or make it the same background colour as the textbox would do. I'm using SelStart = 0 to force the first line, but the flashing cursor spoils the apperance. I think this was why I moved to a label. Hmmm.. any thought? Thanks - Kirk |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can anyone help me with Scrollbars please?
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can anyone help me with Scrollbars please?
I am sorry, but I don't think I can help you with this. My suggestion was
based on things I know how to do with a TextBox over in the compiled world of VB; however, it looks like the TextBoxes over there are completely different that those you can use here in Excel. For example, the way I would handle what you have just asked over in the compiled VB world is to immediately set focus to another control whenever the TextBox got focus. Doing that would mean the cursor would never appear in it. Doing this would still allow the TextBox's scroll bar to work because touching that does not give focus to the TextBox itself. However, it seems that whenever you touch the scroll bar for an Excel TextBox, the TextBox itself gets focus immediately... so the trick won't work in here. Rick "kirkm" wrote in message ... On Sun, 2 Mar 2008 19:39:03 -0500, "Rick Rothstein \(MVP - VB\)" wrote: You can't add scrollbars to a label; however, if I understand why you are asking this question correctly, you can use a TextBox and set its Lock property to True to prevent users from being able to change the text in it. Hi Rick, that's almost got everything I was after. Except the one thing that stuffs it up. How do I turn the cursor off? Or make it the same background colour as the textbox would do. I'm using SelStart = 0 to force the first line, but the flashing cursor spoils the apperance. I think this was why I moved to a label. Hmmm.. any thought? Thanks - Kirk |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can anyone help me with Scrollbars please?
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 |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Scrollbars | Excel Programming | |||
Web Component Scrollbars | Excel Programming | |||
Scrollbars on a Userform | Excel Programming | |||
Scrollbars & Userforms | Excel Programming | |||
ListBox Scrollbars | Excel Programming |