aktualna data po kliknieciu

Article View: pl.comp.lang.vbasic

Article #105009

Back to pl.comp.lang.vbasic Previous Next

#105009

From: usioo8668
Date: Fri, 19 Feb 2016 21:11

9 lines
1489 bytes

Witam,

krótkie pytanko,jak najprościej zapisać makro aby w kolumnie A i wierszach od 9 do nieskończoności ( lub np tyle ile max pozwala arkusz) po kliknięciu w komórkę wypełniała się aktualna datą ?

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Target = Date
End Sub

jak ograniczyć to do kolumny A i wierszy od 9 w dół ?

Technical Details

Message-ID: <8805dfa3-7add-4688-af95-761782372328@googlegroups.com>

Path:

mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!news.icm.edu.pl!newsfeed.pionier.net.pl!takemy.news.telefonica.de!telefonica.de!ecngs!testfeeder.ecngs.de!news.glorb.com!hb3no7262454igb.0!news-out.google.com!kr2ni1181igb.0!nntp.google.com!hb3no7262445igb.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Received: by 10.66.147.106 with SMTP id tj10mr15064058pab.30.1455916288420;        Fri, 19 Feb 2016 13:11:28 -0800 (PST)
X-Received: by 10.182.74.233 with SMTP id x9mr220294obv.19.1455916288319; Fri, 19 Feb 2016 13:11:28 -0800 (PST)
Path: mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!news.icm.edu.pl!newsfeed.pionier.net.pl!takemy.news.telefonica.de!telefonica.de!ecngs!testfeeder.ecngs.de!news.glorb.com!hb3no7262454igb.0!news-out.google.com!kr2ni1181igb.0!nntp.google.com!hb3no7262445igb.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail
Newsgroups: pl.comp.lang.vbasic
Date: Fri, 19 Feb 2016 13:11:28 -0800 (PST)
Complaints-To: groups-abuse@google.com
Injection-Info: glegroupsg2000goo.googlegroups.com; posting-host=178.212.170.81; posting-account=gMiiWAoAAAA7Q-qh1mPAOlwJFRdiVK0J
NNTP-Posting-Host: 178.212.170.81
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <8805dfa3-7add-4688-af95-761782372328@googlegroups.com>
Subject: aktualna data po kliknieciu
From: usioo8668@gmail.com
Injection-Date: Fri, 19 Feb 2016 21:11:28 +0000
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit