Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
'Floating' UserForm
Afternoon!
Does anyone know if it is possible to create a UserForm, which then 'floats' on the screen. ie, you can still play around on the Excel sheet behind it, whilst it is still on the screen. Ta, ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
'Floating' UserForm
Paul,
You can do this in Excel 2000 and later by showing the form modelessly. E.g., Userform1.Show vbModeless -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "paulw" wrote in message ... Afternoon! Does anyone know if it is possible to create a UserForm, which then 'floats' on the screen. ie, you can still play around on the Excel sheet behind it, whilst it is still on the screen. Ta, ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
'Floating' UserForm
Hi
Modeless forms are available in excel 2000 and up. There is a workaround example for Excel97 on Stephen Bullens site. See Modelessform.zip http://www.bmsltd.co.uk/Excel/Default.htm HTH Ken "paulw" wrote in message ... Afternoon! Does anyone know if it is possible to create a UserForm, which then 'floats' on the screen. ie, you can still play around on the Excel sheet behind it, whilst it is still on the screen. Ta, ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.530 / Virus Database: 325 - Release Date: 22/10/2003 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Floating row? | Excel Discussion (Misc queries) | |||
Floating Key | Excel Discussion (Misc queries) | |||
FLOATING CELLS HELP!!! | Excel Discussion (Misc queries) | |||
floating bar chart? | Charts and Charting in Excel | |||
FLOATING BOX | Excel Programming |