question about UserForm initialization

Andrew XJ · Mar 16th, 2002, 02:18 AM

When UserForm is modal, user must respond to it first. But how about read some data and write them to some cell in the Workbook which contains the UserForm?

Dave Hawley · Mar 16th, 2002, 03:41 AM

Hi Andrew

I am a bit confused by your statement:
"When UserForm is modal, user must respond to it first"
What do you mean by that? If a UserForm is Modal (True) the user cannot shift focus back to the Excel Worsheet. In Excel 2000 UserForms now have the ShowModal Property, which by default is True. If this is set to False, Focus can be toggled between the UserForm, it's Controls and also the the Excel Interface, eg Worksheets toolbars etc. What this basically means is, unless you are using Excel 2000 + the UserForm can only be shown as Modal.

_________________
Kind Regards
Dave Hawley
OzGrid Business Applications
Microsoft Excel/VBA Training

[ This Message was edited by: Dave Hawley on 2002-03-16 02:42 ]

Andrew XJ · Mar 16th, 2002, 05:17 AM

Thx u, Dave. I didn't know that we can let the UserForms Non-Modal.

, so made a mistake in my question. I feel Non-Modal UserForms should be better for users and programmers. Why Modal?

Dave Hawley · Mar 16th, 2002, 05:35 AM

Hi Andrew

I half agree with "better for users and programmers". I rarely use the new ability in Excel 2000 as it can (and does) open another base you have to cover. It's bad enough now

Mark O'Brien · Mar 16th, 2002, 09:52 AM

You can actually make Excel 97 userforms "modeless" as well. Although it's not really a feature and is more of an exploitation of a bug. I have to use it when a client was desparate for modeless userforms. I agree though, they are a complete pain.

Andrew XJ · Mar 25th, 2002, 01:57 AM

Dave and Mark, but how to make a userform non-modal in Excel 2000 VBA ? badly need that. I have tried to put Userform1.showModal=False into Auto_Run().
Thx!

regards
Andrew XJ

Dave Hawley · Mar 25th, 2002, 02:16 AM

Hi Andrew

You do this at 'design-time' while in the VBE. Just select your UserForm and then change the "ShowModal" (in the Properties Window) to False.

The ShowModal Property is read only at Run-time!

_________________
Kind Regards
Dave Hawley
OzGrid Business Applications
Microsoft Excel/VBA Training

[ This Message was edited by: Dave Hawley on 2002-03-25 01:19 ]

Andrew XJ · Mar 25th, 2002, 02:28 AM

Thx!

Mar 16th, 2002, 09:52 AM	#5
Mark O'Brien MrExcel MVP Join Date: Feb 2002 Location: Columbus, OH, USA Posts: 3,519	You can actually make Excel 97 userforms "modeless" as well. Although it's not really a feature and is more of an exploitation of a bug. I have to use it when a client was desparate for modeless userforms. I agree though, they are a complete pain. __________________ Mark O'Brien Columbus Ohio Celtic Supporters Club

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 16th, 2002, 02:18 AM	#1
Andrew XJ Board Regular Join Date: Feb 2002 Location: Singapore Posts: 77	When UserForm is modal, user must respond to it first. But how about read some data and write them to some cell in the Workbook which contains the UserForm?

Mar 16th, 2002, 03:41 AM	#2
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	Hi Andrew I am a bit confused by your statement: "When UserForm is modal, user must respond to it first" What do you mean by that? If a UserForm is Modal (True) the user cannot shift focus back to the Excel Worsheet. In Excel 2000 UserForms now have the ShowModal Property, which by default is True. If this is set to False, Focus can be toggled between the UserForm, it's Controls and also the the Excel Interface, eg Worksheets toolbars etc. What this basically means is, unless you are using Excel 2000 + the UserForm can only be shown as Modal. _________________ Kind Regards Dave Hawley OzGrid Business Applications Microsoft Excel/VBA Training [ This Message was edited by: Dave Hawley on 2002-03-16 02:42 ]

Mar 16th, 2002, 05:17 AM	#3
Andrew XJ Board Regular Join Date: Feb 2002 Location: Singapore Posts: 77	Thx u, Dave. I didn't know that we can let the UserForms Non-Modal. , so made a mistake in my question. I feel Non-Modal UserForms should be better for users and programmers. Why Modal?

Mar 16th, 2002, 05:35 AM	#4
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	Hi Andrew I half agree with "better for users and programmers". I rarely use the new ability in Excel 2000 as it can (and does) open another base you have to cover. It's bad enough now

Mar 25th, 2002, 01:57 AM	#6
Andrew XJ Board Regular Join Date: Feb 2002 Location: Singapore Posts: 77	Dave and Mark, but how to make a userform non-modal in Excel 2000 VBA ? badly need that. I have tried to put Userform1.showModal=False into Auto_Run(). Thx! regards Andrew XJ

Mar 25th, 2002, 02:16 AM	#7
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	Hi Andrew You do this at 'design-time' while in the VBE. Just select your UserForm and then change the "ShowModal" (in the Properties Window) to False. The ShowModal Property is read only at Run-time! _________________ Kind Regards Dave Hawley OzGrid Business Applications Microsoft Excel/VBA Training [ This Message was edited by: Dave Hawley on 2002-03-25 01:19 ]

Mar 25th, 2002, 02:28 AM	#8
Andrew XJ Board Regular Join Date: Feb 2002 Location: Singapore Posts: 77	Thx!