Hi Andrew ,
There are two problems in the code which need to be corrected :
1. You are doing two things within your code ; one is to clear the comboboxes , and the second is to clear the contents of the various ranges.
The clearing of the comboboxes is being done correctly , within the "IF user_input = vbYes THEN ... END IF" block.
However , clearing the contents of the various ranges , is being done outside of the block ; so whether the user selects Yes or No , the clearing of the ranges will always be done. Is this what you want to do ? If it is not , then the second End If in your code needs to be moved to just before the End Sub.
2. You are selecting several ranges one after another. However , clearing of the range contents is being done using a Selection.ClearContents method ; here the selection range on which this operates is just the last range which has been selected i.e. BA3.
To actually select multiple ranges , you need to use the Application.Union method as follows :
Application.Union(Range("T4:T17"), Range("T19:T32"), Range("F37:U37"), Range("F40:I40")).Select
will select the four non-contiguous ranges T4:T17 , T19:T32 , F37:U37 and F40:I40.
Narayan