Article View: free.it.visual-basic
Article #887Re: Inserire dati da form in celle Excel
From: ~Incoming
Date: Sat, 12 Feb 2005 00:04
Date: Sat, 12 Feb 2005 00:04
56 lines
2090 bytes
2090 bytes
Ciao, Giorgio!
hai scritto Z7vOd.863592$35.32894425@news4.tin.it
Wed, 09 Feb 2005 21:19:53 GMT:
[skip]
> Fin qui tutto bene.
> Se premo Invio il Setfocus rimane sempre nei 2 campi
tu non premere invio premi TAB
> Il problema sorge che non riesco a trovare il modo per
> far chiudere il Form
> di inserimento quando entrambe le celle hanno preso i dati
> Sto utlizzando questo codice
> Private Sub TxtIva_AfterUpdate()
> Cells(3, 1) = Me.TxtIva
> End Sub
> Private Sub TxtNome_AfterUpdate()
> Cells(7, 1) = Me.TxtNome
> End Sub ******************************
> Grazie 1000
> Giorgio
'cio che segue e' una rozzzzzzata!!!
'megagalattica :-)
Private Const nVal As Integer = 2
Private valInseriti As Integer
Private Sub TxtNome_AfterUpdate()
Cells(7, 1) = Me.TxtNome
testVal
End Sub
Private Sub TxtIva_AfterUpdate()
Cells(3, 1) = Me.TxtIva
testVal
End Sub
Private Sub testVal()
valInseriti = valInseriti + 1
If valInseriti = nVal Then Unload Me
End Sub
Cordialita', ~Incoming.
Technical Details
Message-ID:
<420d4827$0$32351$5fc30a8@news.tiscali.it>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!proxad.net!213.200.89.82.MISMATCH!tiscali!newsfeed1.ip.tiscali.net!draco.tiscalinet.it!news-f1.tiscali.it!not-for-mailReferences:
<Z7vOd.863592$35.32894425@news4.tin.it>Show Full Headers
Complete Article Headers
X-Google-Thread: f94ee,da18f1c10e514961 X-Google-Attributes: gidf94ee,public X-Google-Language: ITALIAN,ASCII-7-bit Path: arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!proxad.net!213.200.89.82.MISMATCH!tiscali!newsfeed1.ip.tiscali.net!draco.tiscalinet.it!news-f1.tiscali.it!not-for-mail From: "~Incoming" <speriamo.che.me.l@cavo.it> Newsgroups: free.it.visual-basic References: <Z7vOd.863592$35.32894425@news4.tin.it> Subject: Re: Inserire dati da form in celle Excel Date: Sat, 12 Feb 2005 01:04:53 +0100 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2900.2180 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 FL-Build: Fidolook 2002 (SL) 6.0.2800.86 - 14/6/2003 22:16:25 X-RFC2646: Format=Flowed; Original X-Comment-To: Giorgio Lines: 58 Message-ID: <420d4827$0$32351$5fc30a8@news.tiscali.it> Organization: Tiscali SpA NNTP-Posting-Host: 62.11.118.132 X-Trace: 1108166696 news.tiscali.it 32351 62.11.118.132:2729 X-Complaints-To: abuse@tiscali.it