ExcelBanter - Edit cells with user form open

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

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Edit cells with user form open (https://www.excelbanter.com/excel-programming/419285-edit-cells-user-form-open.html)

Miree

Edit cells with user form open

I had a lot of macro buttons

so put them into a user form so there was only one button on the sheet.

Is there a way that i can edit the cells with the sheet still open?

Mike H

Edit cells with user form open

Hi,

Set the ShowModal property of the userform to false

Mike

"Miree" wrote:

I had a lot of macro buttons

so put them into a user form so there was only one button on the sheet.

Is there a way that i can edit the cells with the sheet still open?

Miree

Edit cells with user form open

Perfect thanks

"Mike H" wrote:

Hi,

Set the ShowModal property of the userform to false

Mike

"Miree" wrote:

I had a lot of macro buttons

so put them into a user form so there was only one button on the sheet.

Is there a way that i can edit the cells with the sheet still open?

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