10-27-2021
02:59 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report
10-27-2021
02:59 AM
Thanks, that seems to have sorted out the initial issue.
However, I have run into another problem. I need to add more If statements that will modify the size of the headbox (i have attached the table below to detail what is required). I have created the following code that seems to work for the first four statements, but the sizes do not change as they should.
Is there a better code what i need?
If s_o_width <=2500 AndAlso s_o_height <=1500 headbox_depth = 125 headbox_length = 150 Else If s_o_width >2500.01 <5000 AndAlso s_o_height <=1500 headbox_depth = 150 headbox_length = 150 Else If s_o_width <=2500 AndAlso s_o_height >1500.01 <3000 headbox_depth = 150 headbox_length = 150 Else If s_o_width >2500.01 <5000 AndAlso s_o_height >1500.0 <3000 headbox_depth = 180 headbox_length = 180 Else If s_o_width <= 2500 AndAlso s_o_height >3000.01 <6000 headbox_depth = 180 headbox_length = 180 Else If s_o_width >2500.01 <5000 AndAlso s_o_height >3000.01 <6000 headbox_depth = 210 headbox_length = 210 Else If s_o_width <= 2500 AndAlso s_o_height >6000.01 <9000 headbox_depth = 210 headbox_length = 210 Else If s_o_width >2500.01 <5000 AndAlso s_o_height >6000.01 <9000 headbox_depth = 230 headbox_length = 230 Else If s_o_width <= 2500 AndAlso s_o_height >9000.01 <12000 headbox_depth = 230 headbox_length = 230 Else If s_o_width >2500.01 <5000 Andalso s_o_height >9000.01 <12000 headbox_depth = 250 headbox_length = 250 End If