Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() I am trying to mimic a "popup" in excel by setting a group of buttons/labels visible to true or false. My problem comes when I click on a button and that button runs a function to show/hide a the specific group. here's an example Private Sub togShowgrp_Click() If togShowgrp.value = true then showgrp(TRUE) else showgrp(FALSE) End If end sub Function showgrp(Show as Boolean) Application.ScreenUpdating = False lblBackgrd.visible = show cmdPlus1.visible = show cmdMinus1.visible = show Application.ScreenUpdating = True end Function These buttons/labels are on top of a large label already and whenever the button is clicked the screen flickers (all the pictures and labels/buttons on the spreadsheet disappear for a second) My Question is, Is there another way to show the group without the screen flicker using something like Application.ScreenUpdating but on a smaller level, or use the ScreenUpdating a bit better to avoid the annoying flicker? Thanks in Advance. -- Xiazer ------------------------------------------------------------------------ Xiazer's Profile: http://www.excelforum.com/member.php...o&userid=31581 View this thread: http://www.excelforum.com/showthread...hreadid=536722 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
FLICKERING...(fore ground font color with flickering).. | Excel Discussion (Misc queries) | |||
application screenupdating issue | Excel Programming | |||
PLEASE PLEASE HELP Application.Screenupdating | Excel Programming | |||
problem with Application.ScreenUpdating | Excel Programming | |||
Application.ScreenUpdating = False | Excel Programming |