Keep VBA form on screen and still work in document?

[cheriberi]

Is it possible to keep a VBA form on screen and while it's there, reposition cursor manually or do some other manual updating, then make selections on the form?

Thanks!

Cheryl

 

[SkipVought]

Hi,

Set the ShowModal FALSE (xl versions > 97)



Skip,

http://www.TheOfficeExperts.com

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[cheriberi]

Is this possible in Word? I fogot to mention that's the application I'm using. If so, when and where do I set that?

Cheryl

 

[SkipVought]

Yes, it can be done in Word. ShowModal is a property of the userform.

Skip,

http://www.TheOfficeExperts.com

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[cheriberi]

I'm sorry--I can't figure out where to go to set that property! How do you set a property of the userform? I don't see ShowModal in the Properties box.

Cheryl

 

[SkipVought]

What version of Word?

Skip,

http://www.TheOfficeExperts.com

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[cheriberi]

I'm currently using Microsoft Office 97.

Cheryl

 

[SkipVought]

Sorry, can't do it in 97

Skip,

http://www.TheOfficeExperts.com

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[cheriberi]

Oh well...thanks for your help just the same!

Cheryl