View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
keepITcool keepITcool is offline
external usenet poster
 
Posts: 2,253
Default OLE ListBox refresh

untested but to force a repaint you could try
to toggle the control's visibility?


with MyListbox ' or activesheet.olebojects(1)
.visible=false
.visible=true
end with


keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


Ken McLennan wrote:

G'day there again One & All,

I'm currently almost finished a smallish project for my office,
and the last little bit has me stumped.