Re: data in una cella d'excel

Article View: free.it.visual-basic

Article #3490

Back to free.it.visual-basic Previous Next

#3490

From: Claudio
Date: Fri, 21 Jun 2002 14:20

25 lines
1755 bytes

In questo modo nella cella in cui deve apparire la data scrivi:
=oggi()
Tutto qui vedrai comparire la data del sistema.
Senza utilizzare nessun codice VBA.
Ciao Claudio


"Giovanni P" <pitgiov@libero.it> ha scritto nel messaggio
news:udlQ8.41617$Kt3.988220@twister2.libero.it...
> office 2000 -excel- Come faccio a immettere in una cella il valore della
> data, in automatico, quando apro il file? ho sfarfugliato la sootospecie
di
> codice scritto sotto, ma con un'inesperto come me non pu� mai funzionare,
mi
> occorre una mano.
>
> Private Sub Worksheet_Activate() Worksheet('Foglio1').Cells(5, 3).Print
> (Date) End Sub
>
> Ciao
>
>
>
>
>

Technical Details

Message-ID: <YCGQ8.56751$TS.1560171@news1.tin.it>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!supernews.com!mtu.ru!news-out.nuthinbutnews.com!propagator-sterling!news-in.nuthinbutnews.com!isdnet!skynet.be!skynet.be!seanews2.seabone.net!news-out.tin.it!news-in.tin.it!news1.tin.it.POSTED!not-for-mail

References: <udlQ8.41617$Kt3.988220@twister2.libero.it>

Show Full Headers

Complete Article Headers

X-Google-Language: ITALIAN,ASCII
X-Google-Thread: f94ee,e4a34ef3c869fe65
X-Google-Attributes: gidf94ee,public
X-Google-ArrivalTime: 2002-06-21 07:20:44 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!supernews.com!mtu.ru!news-out.nuthinbutnews.com!propagator-sterling!news-in.nuthinbutnews.com!isdnet!skynet.be!skynet.be!seanews2.seabone.net!news-out.tin.it!news-in.tin.it!news1.tin.it.POSTED!not-for-mail
From: "Claudio" <pegocld@libero.it>
Newsgroups: free.it.visual-basic
References: <udlQ8.41617$Kt3.988220@twister2.libero.it>
Subject: Re: data in una cella d'excel
Lines: 27
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4522.1200
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200
Message-ID: <YCGQ8.56751$TS.1560171@news1.tin.it>
Date: Fri, 21 Jun 2002 14:20:40 GMT
NNTP-Posting-Host: 62.211.155.132
X-Complaints-To: newsmaster@tin.it
X-Trace: news1.tin.it 1024669240 62.211.155.132 (Fri, 21 Jun 2002 16:20:40 MET DST)
NNTP-Posting-Date: Fri, 21 Jun 2002 16:20:40 MET DST
Organization: TIN

Reply to Parent Message