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! :)
 

Some videos you may like

Excel Facts

Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.

starl

Administrator
Joined
Aug 16, 2002
Messages
5,959
Office Version
  1. 365
  2. 2019
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
5,959
Office Version
  1. 365
  2. 2019
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!
 

Watch MrExcel Video

Forum statistics

Threads
1,118,521
Messages
5,572,630
Members
412,475
Latest member
JaredNAU
Top