lexxie2013
Board Regular
- Joined
- Nov 28, 2013
- Messages
- 225
Hi all,
in Excel 2013, I've got a textbox on a userform linked via controlsource to a cell. At certain times, I need to change the controlsource. The problem I've got is, if there is sufficient text in the textbox to invoke the vertical scrollbar, when I then change the controlsource to a cell that has little, or no, text, the scrollbar remains. Does anyone know if there is a way I can 'reset' whether the scrollbar is visible depending on the length of content in the new controlsource. Hope that makes sense ! Any help would be greatly appreciated.
in Excel 2013, I've got a textbox on a userform linked via controlsource to a cell. At certain times, I need to change the controlsource. The problem I've got is, if there is sufficient text in the textbox to invoke the vertical scrollbar, when I then change the controlsource to a cell that has little, or no, text, the scrollbar remains. Does anyone know if there is a way I can 'reset' whether the scrollbar is visible depending on the length of content in the new controlsource. Hope that makes sense ! Any help would be greatly appreciated.