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?
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.
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?
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:
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.
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!
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.