View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Carlos Lozano Carlos Lozano is offline
external usenet poster
 
Posts: 18
Default Transparent subform

Hi Kelly,

If all your controls fit in one form; I would use a different approach.
I would create groups of controls for refreshing. Create a 2 dimension array
with the controls names in column one and the refreshing group it belongs to
in column two. Then use timers to fire the refreshing of each group. You can
even fill the array using a for each... next loop.
Each timer will refresh controls of each group only. You can set the timer
interval time.
This way you can move controls to a different group or change the refreshing
time easily.

Hope this helps.

Carlos Lozano
CAX IT Services
www.caxonline.net

"Kelly" wrote:

How do I make a subform with a transparant background?

I want the subform to be an "overlay" to the main form
where only the text boxes on the subform are visible.

The reason for this is that I have a form with many
controls. I refresh the data every 5 seconds. For some of
the values this is not often enough, so I would like to
refresh some of them every second. I pictured I could then
just put my transparent subform on top of the "5-second
values" - and then just refresh some more often.