ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Transparent subform (https://www.excelbanter.com/excel-programming/306995-transparent-subform.html)

kELLY

Transparent subform
 
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.

Carlos Lozano

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.



All times are GMT +1. The time now is 11:13 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com