Your code looks good, instead of activecell try to plug the value...
HTH

            IF sC > 0
               cCell="C"+sRowID
               .Range(cCell).Select()
               .Range(cCell).Value= sC
            ENDIF

>hello,
>
>i have a combobox named DropDown_5 placed on an excel worksheet. from this combobox i am displaying some values which i want a user to select from. On selecting a value from the combobox, i want to put the selected value in cell number C9 of my excel worksheet. I am unable to complete the command sequence below that would help me achieve my objective. Can someone please help me out.
>
>With sincere thanks.
>
>Sub DropDown5_Change()
> Range("C9").Select
> ActiveCell.FormulaR1C1 = .................
>
>End Sub