Combo Box format

[Av8tordude]

I have sheet tabs that are name as years (i.e. 2011), but the sheet tabs are displayed in a combo box as Yr' 2011. How can I format the combo box value back to 2011?

Example

Sheet Tab Name: 2011
Combo box value: Yr '2011

Code has to read value in combo box as 2011

Thank you for your help

 

[Krishnakumar]

May be..

Msgbox replace(combobox.value,"Yr '","")

 

[Av8tordude]

Thank you Kris. Works great!!!