ExcelBanter - Modeless userform

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - Modeless userform (https://www.excelbanter.com/new-users-excel/35028-modeless-userform.html)

hngo

Modeless userform

Hi,

How do we set the user form to modeless.

thanks

Mangesh Yadav

Change the ShowModal property of the userform (in VBE go to View
Properties window).

Mangesh

"hngo" wrote in message
...
Hi,

How do we set the user form to modeless.

thanks

Bob Phillips

You can also do it at runtime

UserForm1.Show 0

--
HTH

Bob Phillips

"Mangesh Yadav" wrote in message
...
Change the ShowModal property of the userform (in VBE go to View
Properties window).

Mangesh

"hngo" wrote in message
...
Hi,

How do we set the user form to modeless.

thanks

All times are GMT +1. The time now is 04:37 AM.