'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,:confused: ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ |
'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,:confused: ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ |
'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,:confused: ------------------------------------------------ ~~ 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 |
All times are GMT +1. The time now is 11:37 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com