Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 12
Default 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.
  #2   Report Post  
Posted to microsoft.public.excel.programming
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.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
subform with 2 requirements and 2 fields deb Excel Discussion (Misc queries) 1 November 6th 09 07:44 PM
subform with 2 requirements and 2 fields deb Excel Discussion (Misc queries) 1 November 6th 09 07:44 PM
Subform not refreshing... Serendipity Excel Worksheet Functions 1 October 31st 08 12:18 PM
form/subform with buttons BAZ Excel Worksheet Functions 0 February 9th 06 04:20 PM
Place Subform data onto specific cells Pantelis Excel Programming 1 July 23rd 03 02:57 PM


All times are GMT +1. The time now is 03:46 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"