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

Have you considered using a floating toolbar instead of a 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
>
>
>

Thanks Jim!

Jos


"Jim Thomlinson" <[email protected]> schreef in
bericht news:[email protected]...
> 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
>>
>>
>>