Makrostart

Forumthread: 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

Re: Makrostart

16.06.2003 11:34:13

RAnton
Re: Makrostart

16.06.2003 11:40:38

Alex
Re: Makrostart

16.06.2003 11:48:16

RAnton
Re: Makrostart

16.06.2003 12:01:08

Alex
Re: Makrostart

16.06.2003 12:05:38

RAnton
Re: Makrostart

16.06.2003 12:13:41

Alex
Re: Makrostart

16.06.2003 12:21:36

RAnton
Re: Makrostart

16.06.2003 12:28:29

Alex
Re: Makrostart

16.06.2003 13:29:23

Alex

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

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

Re: Makrostart

16.06.2003 13:29:23

Alex

==> Neues Topic

Beliebteste Forumthreads (12 Monate)

Forumthread: Makrostart

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

Beliebteste Forumthreads (12 Monate)

9
Beiträge zum Forumthread

Beiträge zu diesem Forumthread