User forms & worksheet help!

  • Thread starter Thread starter mebner
  • Start date Start date
M

mebner

Hello,

I could use some help with this problem. I am trying to use a User for
in conjunction with multiple worksheets. My problem is that the use
form does not release control and I would like to use this form t
update data (via a web service call) on each of the worksheets fo
reporting. On the form I have multiple checkboxes and buttons to choos
which sheets to update. The thing is you do not need to use the form t
view the worksheets. They should be used side by side. Is there a wa
you can toggle between forms & worksheets?

For example, using the form I would select a checkbox then hit th
update button. It would make a call to web svc and the data
associated chart would be updated. Although, as stated before the use
does not need to update the data and each sheet & chart i
pre-populated.

Right now I am not able to do this.

Also, when I move the form another instance is created.

Thanks,

mebne
 
the other instance is because you have screenupdating set to false.

You can show your form vbModeless

Sub showform()
UserForm1.Show vbModeless
End Sub

You must have Excel 2000 or later to do this.
 
Tom,

Thanks for the assist. I am now able to view my worksheets in
conjunction with the user form. One other thing though is that user
form covers up the sheets. Is there some way to minimize this? Or place
it out of the way? I still need to use it, but not all the time. Please
advise.

Mike

Also, I did forget to turn screenupdating back on in a few spots.
 
Back
Top