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

--
Message posted from http://www.ExcelForum.com

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.

--
Regards,
Tom Ogilvy

"mebner " wrote in message
...
Hello,

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

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

Right now I am not able to do this.

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

Thanks,

mebner


---
Message posted from http://www.ExcelForum.com/

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.


---
Message posted from http://www.ExcelForum.com/

http://www.bmsltd.co.ie/Excel/Default.htm

Stephen Bullen's site. Download his formfun.zip file and unzip it. Code is
viewable. Shows about all you can do with userforms.

--
Regards,
Tom Ogilvy

"mebner " wrote in message
...
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.


---
Message posted from http://www.ExcelForum.com/

Tom,
The link you provided was incorrect. Here is the correct one.

http://www.bmsltd.co.uk/Excel/Default.htm

Thanks for letting us know about this!

This file is pretty cool stuff!


---
Message posted from http://www.ExcelForum.com/

Very good... this should be what I need.

thanks..

--
Message posted from http://www.ExcelForum.com

Actually I did screw it up, however, Stephen has request that this be used

http://www.bmsltd.ie/Excel/Default.htm

rather than the one you show. This was a couple of weeks ago, so the
problem may be resolved by now.

--
Regards,
Tom Ogilvy

Full Monty wrote in message
...
Tom,
The link you provided was incorrect. Here is the correct one.

http://www.bmsltd.co.uk/Excel/Default.htm

Thanks for letting us know about this!

This file is pretty cool stuff!


---
Message posted from http://www.ExcelForum.com/