View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim May Jim May is offline
external usenet poster
 
Posts: 477
Default 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