Hi All,

I have a VBA from comobo box (CboMonth) which gatheres its info from the RowSource in the properties. This refs to a named group on a sheet called month.

The form opens and displays the info fine until you click on on the months adn then it changes it to the text format ie Apr-05 becomes 38443 is there anyway of stopping this?

Also when reffering to a sheet is ther a way to referrer to the sheet1 rather that what it is called in the workbook ie in vba projuect the sheets are called sheet1(master) how do i refer to sheet1 rather then "master" in the vba code?

Thanks in advance
Paul