Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
FLOATING GRAPHS | Excel Discussion (Misc queries) | |||
Floating Text Box help | Excel Worksheet Functions | |||
Floating row? | Excel Discussion (Misc queries) | |||
Floating Key | Excel Discussion (Misc queries) | |||
FLOATING BOX | Excel Programming |