B
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
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