PC Review


Reply
Thread Tools Rate Thread

Control don't refresh

 
 
Charlie
Guest
Posts: n/a
 
      8th Feb 2008
Hi,

I'm using some combobox amd listbox controls on one sheet of my workbook.
These controls are refreshed from several sources (other sheets, other
workbooks.) They work fine. The problem is when I refresh them I can't use

Application.ScreenUpdating = No

(macro tasks to update controls)

Application.ScreenUpdating = Yes

as I do when I'm performing other tasks on sheets. If I turn off screen
updating the controls won't refresh. They remain empty, or in some cases
they become "transparent" and I can see sheet gridlines through them when I
turn screen updating on.

For now I'm not using Application.ScreenUpdating and everything works fine
(other than the screen flashing.) Is there a workaround for this problem?

Regards,
Charlie

P.S.
Global Const Yes As Boolean = True
Global Const No As Boolean = False


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Is Control.Invalidate() the same as Control.Refresh ? active Microsoft VB .NET 2 22nd Jun 2007 10:00 PM
Refresh a Control =?Utf-8?B?RGF2ZSBN?= Microsoft Access Forms 4 3rd Apr 2005 12:29 AM
Control.Refresh baramuse Microsoft Dot NET Compact Framework 4 29th Nov 2004 05:25 PM
Control.InValidate vs. Control.Refresh()? Claus Konrad Microsoft C# .NET 1 23rd Apr 2004 01:02 AM
refresh control Rubble Microsoft ASP .NET 2 16th Feb 2004 06:47 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 04:17 PM.