打开用户窗体时如何设置活动文档是否可编辑? [英] How to set active document editable when userform is opened?

查看:216
本文介绍了打开用户窗体时如何设置活动文档是否可编辑?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

我已经创建了userform,如果我打开userform,则无法在打开用户窗体的情况下在活动文档中进行编辑。例如:如果我们按ctrl + f,将显示查找功能对话框,通过保持该对话框打开,我们可以在活动文档中滚动,编辑等。如何做?现在就好了,如果显示警告消息,我们就无法在活动文档中执行任何操作,直到我们关闭该警报消息。我不需要那样。我需要同时处理用户表单和活动文档。



提前谢谢。

I have created userform, If I open userform,am unable to edit in the active document with the userform opened. For example: If we press ctrl+f,the find functionality dialog box will be displayed,by keeping that dialog box opened we can scroll,edit etc in the active document.How to do it? Now its like, if alert message is displayed,we can't to do anything in active document until we close that alert message. I don't need like that. I need to handle both userform and active document simultaneously.

Thanks in advance.

推荐答案

默认情况下所有用户表单都作为模态窗口打开。



要在无模式模式下打开 UserForm ,请使用:

By default all userforms are opened as modal window.

To open UserForm in modeless mode, use:
UserForm1.Show vbModeless





请参阅:显示方法 [ ^ ]


这篇关于打开用户窗体时如何设置活动文档是否可编辑?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆