| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Window into a worksheet while on a form
Is there a way to view part of a worksheet while on a userform? I would like
to have a window on the form that I could see variuos cells in a worksheet and see them change as I selected items on the form. Thanks -- Jason V |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Window into a worksheet while on a form
Maybe in your userform load or show code line add "vbmodeless", like so:
Userform1.Show vbModeless Frees you up from being locked-down from the form. HTH, "Jason V" wrote: Is there a way to view part of a worksheet while on a userform? I would like to have a window on the form that I could see variuos cells in a worksheet and see them change as I selected items on the form. Thanks -- Jason V |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Window into a worksheet while on a form
Just to add to Jim's response...
This was added in xl2k. It won't work in xl97. Jim May wrote: Maybe in your userform load or show code line add "vbmodeless", like so: Userform1.Show vbModeless Frees you up from being locked-down from the form. HTH, "Jason V" wrote: Is there a way to view part of a worksheet while on a userform? I would like to have a window on the form that I could see variuos cells in a worksheet and see them change as I selected items on the form. Thanks -- Jason V -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Window into a worksheet while on a form
This worked for me but it is not exactly what I was hoping for. What I really
wanted was a window on the form that windows me into a portion of a spreadsheet. -- Jason V "Dave Peterson" wrote: Just to add to Jim's response... This was added in xl2k. It won't work in xl97. Jim May wrote: Maybe in your userform load or show code line add "vbmodeless", like so: Userform1.Show vbModeless Frees you up from being locked-down from the form. HTH, "Jason V" wrote: Is there a way to view part of a worksheet while on a userform? I would like to have a window on the form that I could see variuos cells in a worksheet and see them change as I selected items on the form. Thanks -- Jason V -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Window into a worksheet while on a form
I don't think you'll find anything built into excel that allows you to do this.
Jason V wrote: This worked for me but it is not exactly what I was hoping for. What I really wanted was a window on the form that windows me into a portion of a spreadsheet. -- Jason V "Dave Peterson" wrote: Just to add to Jim's response... This was added in xl2k. It won't work in xl97. Jim May wrote: Maybe in your userform load or show code line add "vbmodeless", like so: Userform1.Show vbModeless Frees you up from being locked-down from the form. HTH, "Jason V" wrote: Is there a way to view part of a worksheet while on a userform? I would like to have a window on the form that I could see variuos cells in a worksheet and see them change as I selected items on the form. Thanks -- Jason V -- Dave Peterson -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Create a Window without a Form ... !!! | Excel Programming | |||
| form window too small - Help needed | Excel Programming | |||
| '$' sign in the form window | Excel Programming | |||
| show the form as minimized window | Excel Programming | |||
| How to keep window + form activate together | Excel Programming | |||
![Jason V[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
