Live-Forum - Die aktuellen Beiträge
Datum
Titel
28.03.2024 21:12:36
28.03.2024 18:31:49
Anzeige
Archiv - Navigation
268to272
Aktuelles Verzeichnis
Verzeichnis Index
Übersicht Verzeichnisse
Vorheriger Thread
Rückwärts Blättern
Nächster Thread
Vorwärts blättern
Anzeige
HERBERS
Excel-Forum (Archiv)
20+ Jahre Excel-Kompetenz: Von Anwendern, für Anwender
268to272
268to272
Aktuelles Verzeichnis
Verzeichnis Index
Verzeichnis Index
Übersicht Verzeichnisse
Inhaltsverzeichnis

Makrostart

Makrostart
16.06.2003 11:13:48
Alex
Sorry for the englisch text, my german writing qualities are not so good! REPLYs in GERMAN are OK

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)

9
Beiträge zum Forumthread
Beiträge zu diesem Forumthread

Betreff
Datum
Anwender
Anzeige
Re: Makrostart
16.06.2003 11:34:13
RAnton

Hallo Alex,
Try this


Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
' do the code.....

End Sub

Gruß
RAnton

Re: Makrostart
16.06.2003 11:40:38
Alex

Hallo 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

Re: Makrostart
16.06.2003 11:48:16
RAnton

Hallo Alex,
if you chane a cell in the worksheet, this makro will pop-up the worksheet name. Try it.

Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
msgbox Sh.Name

End Sub


RAnton

Re: Makrostart
16.06.2003 12:01:08
Alex

Ok, I tried your makro, but it doesn't work.
If edit a value in any cell, on any worksheet this function is not being 'called'

Do you have any idea why?

Greetings Alex

Anzeige
Re: Makrostart
16.06.2003 12:05:38
RAnton

did you implement the markro in the workbook?
i.e. open the vbe.explorer end implement the makro in thisWorkbook.

RAnton

Re: Makrostart
16.06.2003 12:13:41
Alex

Ok that was the problem,
That is one problem less!

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

Re: Makrostart
16.06.2003 12:21:36
RAnton

Hy Alex
please open for new question a new thread. This is becouse other people looking for the subject.

RAnton

Re: Makrostart
16.06.2003 12:28:29
Alex

Okay, but first of all I've just encountered a new problem including the makro autostart: it only works when I edit the value by editing the cell value.

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

Anzeige
Re: Makrostart
16.06.2003 13:29:23
Alex

==> Neues Topic

Beliebteste Forumthreads (12 Monate)

Anzeige

Beliebteste Forumthreads (12 Monate)

Anzeige
Anzeige
Anzeige