+ Reply to Thread
Results 1 to 11 of 11

Blurry background on userform launch

  1. #1
    Forum Contributor ABSTRAKTUS's Avatar
    Join Date
    04-18-2010
    Location
    England
    MS-Off Ver
    Win10 Excel 2016
    Posts
    609

    Blurry background on userform launch

    Hi all,

    Could not find anything on Google, thought to ask you guys.

    Is it possible for excel screen to go dim or blurry when the userform is launched? Userform should then remain sharp and lit until closed down and excel sheet goes back to its normal state.

    Thanks all.

  2. #2
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Blurry background on userform launch

    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
    Please consider:

    Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .

  3. #3
    Forum Contributor ABSTRAKTUS's Avatar
    Join Date
    04-18-2010
    Location
    England
    MS-Off Ver
    Win10 Excel 2016
    Posts
    609

    Re: Blurry background on userform launch

    Hi Winon,

    I have no idea how to make excel sheet look blurry or dim the backlight.

    Just imagine you have a regular sheet full of data and different colours. When you launch the userform, I want everything behind that userform to go blurry, pretty much the same way that windows transparent theme does. Basically just because the colour design of the sheet and the userform is similar (requested by client), that userform, when launched "disappears" because of similar colours, but I need it to stand out and catch the eye.

  4. #4
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Blurry background on userform launch

    Hi,

    You could make the Excel application transparent but that might be more distracting as windows below it would show through. I would suggest using an intermediary form that covers the application window and has transparency set before opening the actual form you want to load
    Please Login or Register  to view this content.
    Don
    Please remember to mark your thread 'Solved' when appropriate.

  5. #5
    Forum Contributor ABSTRAKTUS's Avatar
    Join Date
    04-18-2010
    Location
    England
    MS-Off Ver
    Win10 Excel 2016
    Posts
    609

    Re: Blurry background on userform launch

    Just testing. Give me a minute please.

  6. #6
    Forum Contributor ABSTRAKTUS's Avatar
    Join Date
    04-18-2010
    Location
    England
    MS-Off Ver
    Win10 Excel 2016
    Posts
    609

    Re: Blurry background on userform launch

    Yes, you were right. This has dimmed a whole monitor, even the taskbar and excel ribbon, what is a serious limitation, should user would like to switch between windows/workbooks etc.

  7. #7
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Blurry background on userform launch

    Hello ABSTRAKTUS,

    Please try this simplified approach.

    Only Code for UserForm:

    Please Login or Register  to view this content.
    In a Standard Module the Code attached to a Button, below:

    Please Login or Register  to view this content.
    Please try the sample attachment.

    Regards.
    Attached Files Attached Files

  8. #8
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Blurry background on userform launch

    Hi ABSTRAKTUS,

    I missed your statement about imagine you have a regular sheet full of data and different colours.

    This requires a different approach, if my understanding is now correct.

    First of all the Userform needs to be displayed on a Non-Modal state, with the Code as below:

    Please Login or Register  to view this content.
    Now for the tricky workaround to restore the Sheet in question to its original state, we use an extra Sheet which is hidden to preserve the original formats,etc.

    The code for this is also included in a Standard Module, as below:

    Please Login or Register  to view this content.
    Please try the revised attachment below.

    Regards.
    Attached Files Attached Files
    Last edited by Winon; 01-11-2017 at 08:09 PM.

  9. #9
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Blurry background on userform launch

    Quote Originally Posted by ABSTRAKTUS View Post
    Yes, you were right. This has dimmed a whole monitor, even the taskbar and excel ribbon, what is a serious limitation, should user would like to switch between windows/workbooks etc.
    You can resize the form height in the code to not obscure the taskbar and/or ribbon if that is an issue.

  10. #10
    Forum Contributor ABSTRAKTUS's Avatar
    Join Date
    04-18-2010
    Location
    England
    MS-Off Ver
    Win10 Excel 2016
    Posts
    609

    Re: Blurry background on userform launch

    Wow! That is a cool approach! I shall definitely tweak and apply this to my project! Thanks!

  11. #11
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Blurry background on userform launch

    Hi ABSTRAKTUS,

    To whom is your comments directed?LOL

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Userform Launch - show userform when any cell in range on any worksheet is double clicked
    By Armitage2k in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 09-27-2016, 03:38 AM
  2. Unable to launch userform from button on worksheet
    By savferns01 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 01-14-2016, 06:15 AM
  3. Launch application by command button on excel vba userform
    By Benjamin2008 in forum Excel General
    Replies: 1
    Last Post: 12-20-2013, 05:15 PM
  4. [SOLVED] Launch a userform from toolbar instead of command button
    By Clare Smyth in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-19-2013, 12:17 PM
  5. Launch template without userform
    By kemp in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-14-2012, 09:48 AM
  6. How to launch macro or other userform after command button.
    By Karkas in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 04-06-2009, 08:49 PM
  7. Macro launch - Button vs Manual launch , has different results.
    By Wayne in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-23-2005, 08:06 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1