| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
A control that does not scroll with worksheet
I would like to put a control on the right side of the worksheet and
if the user scrolls up and down this control should remain stationary. My main interest is to show some reference information while the user is entering data so the control can take the form of a label, textbox, comment etc. Is there a way to do this? Thank you John |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
A control that does not scroll with worksheet
You can place the control either (1) within a frozen pane or (2) on a
floating toolbar. -- Vasant "John" wrote in message om... I would like to put a control on the right side of the worksheet and if the user scrolls up and down this control should remain stationary. My main interest is to show some reference information while the user is entering data so the control can take the form of a label, textbox, comment etc. Is there a way to do this? Thank you John |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
A control that does not scroll with worksheet
Or a modeless userform?
-- Olly "Vasant Nanavati" <vasantn *AT* aol *DOT* com wrote in message ... You can place the control either (1) within a frozen pane or (2) on a floating toolbar. "John" wrote in message om... I would like to put a control on the right side of the worksheet and if the user scrolls up and down this control should remain stationary. My main interest is to show some reference information while the user is entering data so the control can take the form of a label, textbox, comment etc. Is there a way to do this? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
A control that does not scroll with worksheet
Thank you very much, this is exactly what I needed
John "Olly" wrote in message ... Or a modeless userform? -- Olly "Vasant Nanavati" <vasantn *AT* aol *DOT* com wrote in message ... You can place the control either (1) within a frozen pane or (2) on a floating toolbar. "John" wrote in message om... I would like to put a control on the right side of the worksheet and if the user scrolls up and down this control should remain stationary. My main interest is to show some reference information while the user is entering data so the control can take the form of a label, textbox, comment etc. Is there a way to do this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Scroll Bar Control | Excel Discussion (Misc queries) | |||
| Scroll bar (control) doesn't scroll!! ??? | Excel Worksheet Functions | |||
| Scroll bar control doesn't scroll !! ??? | Setting up and Configuration of Excel | |||
| Out of control scroll lock?? | Excel Discussion (Misc queries) | |||
| Allow use of a control scroll bar in protected worksheet | Excel Discussion (Misc queries) | |||
![John[_35_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
