Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 134
Default 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


  #2   Report Post  
Posted to microsoft.public.excel.programming
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



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 134
Default 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





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
FLOATING GRAPHS Jase Excel Discussion (Misc queries) 1 April 10th 08 02:33 AM
Floating Text Box help Ty Barrett (VMC) Excel Worksheet Functions 2 December 7th 07 07:54 PM
Floating row? pause café Excel Discussion (Misc queries) 2 January 24th 07 11:47 PM
Floating Key Mr-Re Man Excel Discussion (Misc queries) 1 March 21st 06 12:08 AM
FLOATING BOX Fernando Duran Excel Programming 5 September 12th 03 06:13 PM


All times are GMT +1. The time now is 02:46 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"