your code for Hide and Show is identical so the combobox never gets hidden..
you need to change the hide code. .
also read up on how and when to use some elements like
with ..end with - you use when you want to do multiple changes on 1 range or worksheet not if you only have 1 change to make
same for declaring, setting and using variables. for only 1 time use it is pointless..
following code does exactly the same as above
As an alternative code you can also directly link the combobox state to the row state
The outcome of Rows(58).Hidden will be true or false and thus will show or hide the combobox depending on if the row is visible.
this way you only need 1 code to handle hiding and showing the combobox.
Bookmarks