"However the worksheet_change event is not occurring eventhough the cell link is
updating with list index of combo box. "
Have you turned off events and forgot to turn them back on? Or during a debug,
stopped a macro before it was able to turn events back on? Are other event
macros working in your file?
Application.EnableEvents = False
Application.EnableEvents = True