Window into a worksheet while on a form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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,
 
Just to add to Jim's response...

This was added in xl2k. It won't work in xl97.
 
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.
 
I don't think you'll find anything built into excel that allows you to do this.

Jason said:
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.
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hidden sheet bleeds through 3
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Run-time error '380' Invalid property value. 1
inconsistent dir() behavior 1
CheckBox values based on Worksheet condition 2
Display one sheet or two userforms while code is vba code is runningon another 1
UserForm - pointing control source to new sheet - long delay 5
Allow text in locked cells on a worksheet from a userform 16

Back
Top