Select sh. error

[Craig2015]

Hi Guys,

About 5 years ago I spent a lot of time making a workbook for a friend with a lot of help from forums. The workbook contains a userform to add data about customers and their spend. The workbook has stopped working and is coming up with a few different vba errors. I can't for the life of me remember how I made all the little bits of code. A lot of google and help as I said. The errors look quite simple "not for me". The Operating system and computer was upgraded is all I know about why it stopped working.

Basically there is a userform with a combobox to select customers from a list on a separate sheet or you could add a new customer if they were not on the list.
The date"actually yesterdays date should populate automatically
You enter the spend and then update which should transfer all the data to a main sheet.

I've attached the workbook if anyone might be able to help?

Cheers

[mehmetcik]

Hi Craig

This is using a Datepicker

The latest version of excel does not support a datepicker.............Why??????????????????

So I will add a userform that will do the datepicker's job for you.


Sorry your file is badly corrupted.

I cannot do anything with it.

[Craig2015]

Thanks for trying mehmetcik