Thread: Floating Form
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Thomlinson[_3_] Jim Thomlinson[_3_] is offline
external usenet poster
 
Posts: 983
Default Floating Form

The show method of a form takes one argument, "Modal". By default it is true
and it will not allow you to access anything off of that form. Specify it as
false and you can modify the cells while the form is still active.
for example:
Form1.Show False

HTH
"Jos Vens" wrote:

Hi,

I like to show a picture of a person when someone is still able to input
data in cells.

Is it possible to make a userform "floating" so you can type in cells when
the form is open?

Thanks,
Jos Vens