|
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 |
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 |
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 |
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 |
| All times are GMT +1. The time now is 03:08 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com