I need some help with combobox's it's my first time Using those on Userform.
1. Combobox1 should look at Column "E" for Cell with "1" to "7" ---> "1" from E325:E452 (it's for the first 128 Players in Cupsystem)
---> "2" from E453:E516 (it's for the next 64 Players witch is further in Cupsystem)
---> "3" from E517:E548 (it's for the next 32 Players witch is further in Cupsystem)
---> "4" from E549:E564 (it's for the next 16 Players witch is further in Cupsystem)
---> "5" from E565:E572 (it's for the next 8 Players witch is further in Cupsystem)
---> "6" from E573:E576 (it's for the next 4 Players witch is further in Cupsystem)
---> "7" from E577:E578 (it's for the Final Players in Cupsystem)
2. Combobox2 if Combobox1 is "1" then Only Column ("F325:F452") is activated and ("F453:F578") can not been Selected.
if Combobox1 is "2" then Only Column ("F453:F516") is activated and ("F325:F452") and ("F517:F578") can not been Selected.
if Combobox1 is "3" then Only Column ("F517:F548") is activated and ("F453:F516") and ("F549:F578") can not been Selected.
if Combobox1 is "4" then Only Column ("F549:F564") is activated and ("F453:F548") and ("F565:F578") can not been Selected.
if Combobox1 is "5" then Only Column ("F565:F572") is activated and ("F453:F564") and ("F572:F578") can not been Selected.
if Combobox1 is "6" then Only Column ("F573:F576") is activated and ("F453:F572") and ("F577:F578") can not been Selected.
if Combobox1 is "7" then Only Column ("F577:F578") is activated and ("F453:F575") can not been Selected.
Any one of those who is selected from Combobox 2 should been showen on sheet's Note for Batle in Cell ("D1")
3. Combobox3 if Combobox1 is "1" then Only Column ("F325:F452") is activated and ("F453:F578") can not been Selected.
if Combobox1 is "2" then Only Column ("F453:F516") is activated and ("F325:F452") and ("F517:F578") can not been Selected.
if Combobox1 is "3" then Only Column ("F517:F548") is activated and ("F453:F516") and ("F549:F578") can not been Selected.
if Combobox1 is "4" then Only Column ("F549:F564") is activated and ("F453:F548") and ("F565:F578") can not been Selected.
if Combobox1 is "5" then Only Column ("F565:F572") is activated and ("F453:F564") and ("F572:F578") can not been Selected.
if Combobox1 is "6" then Only Column ("F573:F576") is activated and ("F453:F572") and ("F577:F578") can not been Selected.
if Combobox1 is "7" then Only Column ("F577:F578") is activated and ("F453:F575") can not been Selected.
Any one of those who is selected from Combobox 3 should been showen on sheet's Note for Batle in Cell ("D4")
I hope that was Enough Info
sorry But have No file yet to show
1. Combobox1 should look at Column "E" for Cell with "1" to "7" ---> "1" from E325:E452 (it's for the first 128 Players in Cupsystem)
---> "2" from E453:E516 (it's for the next 64 Players witch is further in Cupsystem)
---> "3" from E517:E548 (it's for the next 32 Players witch is further in Cupsystem)
---> "4" from E549:E564 (it's for the next 16 Players witch is further in Cupsystem)
---> "5" from E565:E572 (it's for the next 8 Players witch is further in Cupsystem)
---> "6" from E573:E576 (it's for the next 4 Players witch is further in Cupsystem)
---> "7" from E577:E578 (it's for the Final Players in Cupsystem)
2. Combobox2 if Combobox1 is "1" then Only Column ("F325:F452") is activated and ("F453:F578") can not been Selected.
if Combobox1 is "2" then Only Column ("F453:F516") is activated and ("F325:F452") and ("F517:F578") can not been Selected.
if Combobox1 is "3" then Only Column ("F517:F548") is activated and ("F453:F516") and ("F549:F578") can not been Selected.
if Combobox1 is "4" then Only Column ("F549:F564") is activated and ("F453:F548") and ("F565:F578") can not been Selected.
if Combobox1 is "5" then Only Column ("F565:F572") is activated and ("F453:F564") and ("F572:F578") can not been Selected.
if Combobox1 is "6" then Only Column ("F573:F576") is activated and ("F453:F572") and ("F577:F578") can not been Selected.
if Combobox1 is "7" then Only Column ("F577:F578") is activated and ("F453:F575") can not been Selected.
Any one of those who is selected from Combobox 2 should been showen on sheet's Note for Batle in Cell ("D1")
3. Combobox3 if Combobox1 is "1" then Only Column ("F325:F452") is activated and ("F453:F578") can not been Selected.
if Combobox1 is "2" then Only Column ("F453:F516") is activated and ("F325:F452") and ("F517:F578") can not been Selected.
if Combobox1 is "3" then Only Column ("F517:F548") is activated and ("F453:F516") and ("F549:F578") can not been Selected.
if Combobox1 is "4" then Only Column ("F549:F564") is activated and ("F453:F548") and ("F565:F578") can not been Selected.
if Combobox1 is "5" then Only Column ("F565:F572") is activated and ("F453:F564") and ("F572:F578") can not been Selected.
if Combobox1 is "6" then Only Column ("F573:F576") is activated and ("F453:F572") and ("F577:F578") can not been Selected.
if Combobox1 is "7" then Only Column ("F577:F578") is activated and ("F453:F575") can not been Selected.
Any one of those who is selected from Combobox 3 should been showen on sheet's Note for Batle in Cell ("D4")
I hope that was Enough Info
sorry But have No file yet to show
Last edited: