ExcelBanter - Quick Code

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Quick Code (https://www.excelbanter.com/excel-discussion-misc-queries/109375-quick-code.html)

Nimish

Quick Code

What is the VBA code to allow a user to edit a worksheet while a form
is open?

Dave Peterson

Quick Code

If you're using xl2k or higher:

UserForm1.Show vbModeless

Nimish wrote:

What is the VBA code to allow a user to edit a worksheet while a form
is open?

--

Dave Peterson

Kevin B

Quick Code

YourFormName.Show vbModeless

--
Kevin Backmann

"Nimish" wrote:

What is the VBA code to allow a user to edit a worksheet while a form
is open?

Toppers

Quick Code

Try:

Userform1.show vbmodeless

"Nimish" wrote:

What is the VBA code to allow a user to edit a worksheet while a form
is open?

All times are GMT +1. The time now is 07:26 PM.