Posted to microsoft.public.excel.programming

kirkm[_6_] kirkm[_6_] is offline

external usenet poster

Posts: 156

Modal/Modeless Forms

Is there any way to have a form modeless in Excel 2002
but model in Excel 97.

I was playing with this

If Val(Application.Version) = 8 Then
frmLabel.Show
Else: frmLabel.Show vbModeless
End If

but the Else clause causes an error in Excel 97 (which
I can't trap out).

Thanks - Kirk

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel Forms-Can i set the modal property?	dpt[_6_]	Excel Programming	3	August 9th 05 04:39 AM
How to make values of spreadsheet show in a modeless forms text bo	Chirs	Excel Programming	3	June 11th 05 01:50 PM
Forms that are modal in 97 are not modal in 2003	Old Car	Excel Discussion (Misc queries)	1	April 27th 05 08:25 AM
Forms that are modal in 97 are not modal in 2003	Old Car	Excel Programming	1	April 27th 05 08:25 AM
Modal Forms	MJRay	Excel Programming	1	March 8th 05 05:09 PM

All times are GMT +1. The time now is 02:11 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us