ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Work Underneath a User form (https://www.excelbanter.com/excel-programming/298997-work-underneath-user-form.html)

peekbo

Work Underneath a User form
 
I just have started to use VB. I have a created a user form that ope
each time that my workbook is open. The userform contins differen
buttons that hide columns for a quick comparison of data. But wheneve
the userform is open you can not manipulate the spreadsheet. I woul
like to be able scholl and change data with the user form open.

Any suggestions would be great!

Thanks
Bria

--
Message posted from http://www.ExcelForum.com


Charles

Work Underneath a User form
 
Brian,

Make your user form a modeless

Userform1.show vbModeless

HTH

Charle

--
Message posted from http://www.ExcelForum.com


peekbo[_2_]

Work Underneath a User form
 
Awesome! Thank you for thw swift reply

--
Message posted from http://www.ExcelForum.com



All times are GMT +1. The time now is 02:04 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com