ComboBox Event Procedure problem

[Brent McIntyre]

Hi there,

Although I haven't come across this exact problem I have
come across a number of problems when trying to acheive an
action when triggered by a Change on a Combo/List Box.

My advice would be to make the change with the ComboBox
and then have a seperate procedure for saving the workbook.

This should work, you may find some information on a work
around on the Microsoft site, but it is unlikely, I found
some about a year ago, basically it said that VBA is a cut
down VB version 6.0 there was no fix and there wasn't
going to be.

Sorry to be the bearer of bad news.

Yours sincerely,

Brent McIntyre

 

[newboy18]

Thanks but it was a fauly spreadsheet, I copied all the
sheets into another workbook and then recreated the
ComboBox and it all works OK now