The Combox1_Change routine is an event assigned to the combo box. It happens automatically when a change is made to the selections of the combo box. You can't call the routine the way you are attempting to do (hence the "method" error). Whatever code you have in the combo box_Change routine will occur when you select something from the combo box. If you are assigning a value to your combo box with the "S" variable, then the Change code should be automatically activated, but not until you close the box, or make some other selection change.