Hi,
do you want to use one combobox for more than one line?
You can adapt the list of a combobox by right-click -> properties and change "ListFillRange"-property. This can be as in the example on another sheet, this sheet can be hidden if you like.
If you change the number of rows per line you will have to adapt this in the code at
Please note: Each button must be located in the column where the time has to be written into.
Do not change the order of the columns "", "" and "" otherwise you'll have to adapt the code in
and
Test 6.xlsm
Regards
Bookmarks