Try adding stuff like

MsgBox CmbRef.Value

and so on to check what values are being passed around.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Soniya" wrote in message
oups.com...
When Added this:
after CmbRef.ListIndex = CmbRef.ListIndex + 1

MsgBox ("Now the Text shud change")

it shows the msgbox and changes the text box...
I know it changes but not get displayed in the text box.
because the sound changes and the the fist two cells show then last
cell value is shown in the text box. it fails to display from third
onwards..

I tried to set ScreenUpdating to true still not working...
Code works, but the text not displyed..

thanks..!