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

[fwesterv]

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!

 

[starl]

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]

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

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!

 

[starl]

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!