ExcelBanter - edit data while form open

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

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

- - edit data while form open (https://www.excelbanter.com/excel-programming/309147-edit-data-while-form-open.html)

questy

edit data while form open

in sheet I found that when a userform is open in a sheet I can't edit the
data even when I collapse the userform. Is there anything to do to avoid
this.
Thanks in Advance

Vasant Nanavati

edit data while form open

Make the UserForm modeless:

UserForm1.Show vbModeless

--

Vasant

"questy" wrote in message
...
in sheet I found that when a userform is open in a sheet I can't edit the
data even when I collapse the userform. Is there anything to do to avoid
this.
Thanks in Advance

All times are GMT +1. The time now is 10:26 AM.