Floating Form
 

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

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

Floating Form
 

Thanks Jim!

Jos


"Jim Thomlinson" schreef in
bericht ...
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