Transparent Forms pgs 457-458 in VBA & MACROS FOR MS EXC

fwesterv

New Member
Joined
Nov 28, 2005
Messages
2
I want to use "Transparent Forms" as described in this excellent Book, but I need to read some COMMENTS on the Code shown to really understand exactly WHAT is going on and HOW to modify the Code (if needed) to tailor it to "fit" various applications.

I think that others may also appreciate getting "the details" of this Form too.
Many Thanks for any Help on this question! :)
 

Excel Facts

Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.

starl

Administrator
Joined
Aug 16, 2002
Messages
6,001
Office Version
  1. 365
Platform
  1. Windows
  2. MacOS
The code offered is somewhat outside the realms of VBA - tho you can call it in VBA and manipulate it some, it's an API function - not something we went into detail about in the book. If you want to change a part of it, you need to be more specific - because what you want to change may not be possible.
If you want to change the transparency, then play with the numbers in this section : (255*50)/100 -those are the numbers that control the transparency. The current value is actually 127.50 - but you could try playing with other numbers and see how it affects the form.
 

fwesterv

New Member
Joined
Nov 28, 2005
Messages
2
Windows API "details"

OK... "The Book" offers Chapter 22 titled "Windows Application Programming Interface (API)" beginning on page 459 (the very next page after the "Transparent Forms" (TF) example). IMO, Chapter 22 was a marvelous opportunity to provide the very "details" needed to understand this example, but it clearly missed the chance to do so... :cry:

Thanks for identifying the ONE VBA line that does modify the "transparency" of the TF at the very top of page 458 (where it is much too easy to overlook its singular importance and structure for the TF example).

This TF example (with copious Explanatory Comments) probably should be IN Chapter 22, instead of Chapter 21, in the next Edition of the Book, IMO.

Thanks again! :biggrin:
 

starl

Administrator
Joined
Aug 16, 2002
Messages
6,001
Office Version
  1. 365
Platform
  1. Windows
  2. MacOS
You're right - we could have put it in the next chapter and just referenced it in the previous chapter.. but when you're writing stuff on a deadline.. even the most obvious can escape you!
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,163,805
Messages
5,833,773
Members
430,232
Latest member
Testsubject

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top