Combobox's

Hjemmet

Board Regular
Joined
Jun 20, 2018
Messages
207
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
 
Last edited:

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).

Forum statistics

Threads
1,223,236
Messages
6,170,906
Members
452,366
Latest member
TePunaBloke

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top