Work Underneath a User form

  • Thread starter Thread starter peekbo
  • Start date Start date
P

peekbo

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
 
Brian,

Make your user form a modeless

Userform1.show vbModeless

HTH

Charle
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Checking to see if a user form is hidden 5
Reference a workbook chosen by a user from a userform 4
closing another file by code causes failure to run workbook activate event 2
HELP: Application.Visible issue - only hide workbook that has user 4
how to reshow userform after following a link 1
inconsistent dir() behavior 1
how do I link a constant or variable to form 3
To protect user's privacy 1

Back
Top