Can you show a form in Excel that is not Modal

[Red Eye]

I am using a VBform in excel to show a summary of some data, while the form is showing I would like to keep it on top and use excel as normal.

I'm not sure that it is possible to do this.

Currently the form is modal and I have to close the form and then open it again.

Any ideas?

 

[Richie(UK)]

Hi Red Eye,

Welcome to the board.

I think it depends on what verson of Excel you are using. I have Excel97, which doesn't have modeless Userforms. However, I believe later versions (2000 onwards?) do have this ability.

Can anyone confirm this?