Dear readers,
For weeks, I've been trying to make a makro start when a cell-value is changed. Unfortunately it still doesn't work!
Is there anyone who can help me with this?
Thanks in advance,
Alex (NL)
Dear readers,
For weeks, I've been trying to make a makro start when a cell-value is changed. Unfortunately it still doesn't work!
Is there anyone who can help me with this?
Thanks in advance,
Alex (NL)
Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
' do the code.....
End Sub
Gruß
RAnton
First of all, thanks for your support!
Is there anything I need to edit in this function, ie the words Object or Target?
Alex
Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
msgbox Sh.Name
End Sub
RAnton
Do you have any idea why?
Greetings Alex
RAnton
Do you happen to know how I can start the Excel-workbook automatically with a form? Is there also a possibility to block the close = [x] button of the form?
Greetings Alex
RAnton
A small example:
I have a cell containing the formula =SECOND(NOW())
Everytime I press calculate (F9) the cell-value is changed, but the Makro isn't starting.
The same problem occurs when I change the cell-value through a DDE (Dynamic Data Exchange) connection
Can you also help with this?
Alex