Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
subform with 2 requirements and 2 fields | Excel Discussion (Misc queries) | |||
subform with 2 requirements and 2 fields | Excel Discussion (Misc queries) | |||
Subform not refreshing... | Excel Worksheet Functions | |||
form/subform with buttons | Excel Worksheet Functions | |||
Place Subform data onto specific cells | Excel Programming |