Combobox Change On Save As
Hello, I have a file with a large number of combobox controls on several sheets. On SaveAs, every combobox change sub runs, which resets many of the combobox values. I saw in a previous thread that this is due to the comboboxes being linked to cells, and the recalculate before save. Even if I turn the autocalculate off before saving, some still change, and others change when I turn the calculations back on. I need to store the selections from the comboboxes, so I must link them to cells. How can I avoid them changing? Thank you!!! -- jbl25 ------------------------------------------------------------------------ jbl25's Profile: http://www.excelforum.com/member.php...fo&userid=7225 View this thread: http://www.excelforum.com/showthread...hreadid=381852 |
Combobox Change On Save As
You could set an event flag to bypass its action
Public fDisableEvents As Boolean Private Sub ComboBox1_Change() If Not fDisableEvents Then MsgBox ComboBox1.Value End If End Sub and disable the flag before the SaveAs. -- HTH Bob Phillips "jbl25" wrote in message ... Hello, I have a file with a large number of combobox controls on several sheets. On SaveAs, every combobox change sub runs, which resets many of the combobox values. I saw in a previous thread that this is due to the comboboxes being linked to cells, and the recalculate before save. Even if I turn the autocalculate off before saving, some still change, and others change when I turn the calculations back on. I need to store the selections from the comboboxes, so I must link them to cells. How can I avoid them changing? Thank you!!! -- jbl25 ------------------------------------------------------------------------ jbl25's Profile: http://www.excelforum.com/member.php...fo&userid=7225 View this thread: http://www.excelforum.com/showthread...hreadid=381852 |
Combobox Change On Save As
Maybe in Workbooks_BeforeSave event set Application.Calculation =
xlCalsulationManual ? I'm not sure why it is preferrable to block of excel calculation, unless this is a performance issue DM Unseen |
Combobox Change On Save As
Hello, I tried disabling all workbook events right before saving, and also tried setting calculations to manual before save, but the comboboxes still changed. I have excel 2003 and have installed Hotfix SP1. Are there any other solutions? Thanks very much. -- jbl25 ------------------------------------------------------------------------ jbl25's Profile: http://www.excelforum.com/member.php...fo&userid=7225 View this thread: http://www.excelforum.com/showthread...hreadid=381852 |
Combobox Change On Save As
unlink the cells and use the click event to write the values to the cells.
-- Regards, Tom Ogilvy "jbl25" wrote in message ... Hello, I tried disabling all workbook events right before saving, and also tried setting calculations to manual before save, but the comboboxes still changed. I have excel 2003 and have installed Hotfix SP1. Are there any other solutions? Thanks very much. -- jbl25 ------------------------------------------------------------------------ jbl25's Profile: http://www.excelforum.com/member.php...fo&userid=7225 View this thread: http://www.excelforum.com/showthread...hreadid=381852 |
All times are GMT +1. The time now is 12:49 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com