question about UserForm initialization

[Andrew XJ]

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]

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]

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]

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 :wink:

 

[Mark O'Brien]

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]

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]

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]

Thx!