Hi there again
This one is a bit above my ability
See the attached workbook:
On the VBA form Glass , go to the Fenestration Tab, on the SHGC sub tab:
The variables
P/H value (txtPHvalue)
The orientation (The combobox)
The Zone (in the lower right corner)
Now, based on the Zone and the orientation, I am looking for a code that will find the value in the shading sheet in Col A
The Shading Sheet consist of 6 Tables, one for each Zone. It is clearly marked.
An example what t must do
When the P/H value is 0.21, the Zone is 4 it must find the value nearest to 0.21 in the table A83:107 (which is the table for Zone 4). Then, with the orientation to south, it must find the value in the F column (which is south)
I know it is quite complicated, but I wil really really appreciate some help
Best regards,
Jakes
Fenestration Calculator.xlsm
Bookmarks