You don't say whether it's a form control or an Active X control. For a form control, you might be stuck. For an Active X control, you can use the ComboBox_Change event to pick up changes made via the combo box. This will also fire if you change the linked cell directly, because that changes the combo box value.. Regards, Dave S ----- Original Message ----- From: "Tayyab" <sheikhtayyab@yahoo.com> To: <ExcelVBA@yahoogroups.com> Sent: Friday, May 31, 2013 10:50 PM Subject: [ExcelVBA] auto run macro when link formula change hi I have a sheet that have a combo box selection menu to select code, when code is selected sheet auto changes value. then also have...
Jumat, 31 Mei 2013
Re: [ExcelVBA] auto run macro when link formula change
I think what you're saying is that you have a combobox on the worksheet (not in a userform) and your Worksheet_Change event works when you change a cell value, but not when you change the combobox selection. If that's the case, then there's nothing you can do about it. The VALUE of the combobox is NOT the selection, but the LINK to the combobox values. Technically, what you SEE in the cell is actually a property of the combobox, not the VALUE of the cell. changing the selection does not change the LINK, therefore, the event doesn't recognize that there has been any "change" to the worksheet. You MIGHT be able to set up a Public variable. Then utilize a SelectionChange...
RES: [ExcelVBA] auto run macro when link formula change
Try using event Calculate instead of Change Private Sub Worksheet_SelectionChange(ByVal Target As Range) Call HideColumns End Sub De: ExcelVBA@yahoogroups.com [mailto:ExcelVBA@yahoogroups.com] Em nome de Tayyab Enviada em: sexta-feira, 31 de maio de 2013 09:51 Para: ExcelVBA@yahoogroups.com Assunto: [ExcelVBA] auto run macro when link formula change hi I have a sheet that have a combo box selection menu to select code, when code is selected sheet auto changes value. then also have a macro that I want to run . macro only run when I change any cell value, but not run when changing the combo option. I make attach code. Please help Private Sub Worksheet_Change(ByVal...
[ExcelVBA] auto run macro when link formula change
hi I have a sheet that have a combo box selection menu to select code, when code is selected sheet auto changes value. then also have a macro that I want to run . macro only run when I change any cell value, but not run when changing the combo option. I make attach code. Please help Private Sub Worksheet_Change(ByVal Target As Range) Dim KeyCells As Range Set KeyCells = Range("g6:i10") 'combo box link cell If Not Application.Intersect(KeyCells, Range(Target.Address)) _ Is Nothing Then...
[smf_addin] Digest Number 2638
EXCEL Stock Market Functions Add-in Group 8 New Messages Digest #2638 1a Re: #NAME problem for smfGetOptionQuotes() function by "terminal3screensdesk" terminal3screensdesk 1b Re: #NAME...
Langganan:
Postingan (Atom)