| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
userform text box and a scroll bar
I have never used a scroll bar in conjunction with a text box. Please help.
I have userform CCLCFC I have text box txtbxexplain I have scrollbar scbrexplian Via VBA I want to tie scbrexplain to txtbxexplain so that when one uses the scrollbar he/she can scroll up and down through the information in the text box. Please help. -- Thanks Shawn |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
userform text box and a scroll bar
Rather than having two separate controls for that, wouldn't you simply
want to set the "ScrollBars" property of the textbox to "2 - fmScrollBarsVertical"? Shawn wrote: I have never used a scroll bar in conjunction with a text box. Please help. I have userform CCLCFC I have text box txtbxexplain I have scrollbar scbrexplian Via VBA I want to tie scbrexplain to txtbxexplain so that when one uses the scrollbar he/she can scroll up and down through the information in the text box. Please help. -- Thanks Shawn |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
userform text box and a scroll bar
Oh, and set the "MultiLine" property of the textbox to "True" as
well... wrote: Rather than having two separate controls for that, wouldn't you simply want to set the "ScrollBars" property of the textbox to "2 - fmScrollBarsVertical"? Shawn wrote: I have never used a scroll bar in conjunction with a text box. Please help. I have userform CCLCFC I have text box txtbxexplain I have scrollbar scbrexplian Via VBA I want to tie scbrexplain to txtbxexplain so that when one uses the scrollbar he/she can scroll up and down through the information in the text box. Please help. -- Thanks Shawn |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
userform text box and a scroll bar
Great. Two issues. Why doesn't the scroll bar appear when the userform
initializes? It doesn't appear unless I click the text box. 2nd...when I click the text box it automitically jumps to the end of the text instead of staying at the begining??? -- Thanks Shawn " wrote: Oh, and set the "MultiLine" property of the textbox to "True" as well... wrote: Rather than having two separate controls for that, wouldn't you simply want to set the "ScrollBars" property of the textbox to "2 - fmScrollBarsVertical"? Shawn wrote: I have never used a scroll bar in conjunction with a text box. Please help. I have userform CCLCFC I have text box txtbxexplain I have scrollbar scbrexplian Via VBA I want to tie scbrexplain to txtbxexplain so that when one uses the scrollbar he/she can scroll up and down through the information in the text box. Please help. -- Thanks Shawn |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
userform text box and a scroll bar
I'm not trying to be a smart alec (much is lost in text-only
communication), but that's the way the scroll bars work in Microsoft's Excel textbox control. Shawn wrote: Great. Two issues. Why doesn't the scroll bar appear when the userform initializes? It doesn't appear unless I click the text box. 2nd...when I click the text box it automitically jumps to the end of the text instead of staying at the begining??? -- Thanks Shawn " wrote: Oh, and set the "MultiLine" property of the textbox to "True" as well... wrote: Rather than having two separate controls for that, wouldn't you simply want to set the "ScrollBars" property of the textbox to "2 - fmScrollBarsVertical"? Shawn wrote: I have never used a scroll bar in conjunction with a text box. Please help. I have userform CCLCFC I have text box txtbxexplain I have scrollbar scbrexplian Via VBA I want to tie scbrexplain to txtbxexplain so that when one uses the scrollbar he/she can scroll up and down through the information in the text box. Please help. -- Thanks Shawn |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Text Box w/Scroll Bar | Excel Discussion (Misc queries) | |||
| Activating scroll bars in a text box on a userform | Excel Programming | |||
| Scroll Bars in TextBox on UserForm | Excel Programming | |||
| Text box Scroll bar position | Excel Programming | |||
| Userform and scroll bars | Excel Programming | |||
Linear Mode
