Article View: free.it.visual-basic
Article #888Re: Inserire dati da form in celle Excel
From: Giorgio
Date: Sat, 12 Feb 2005 13:46
Date: Sat, 12 Feb 2005 13:46
66 lines
2426 bytes
2426 bytes
1000 Grazie Saluti Giorgio "~Incoming" <speriamo.che.me.l@cavo.it> ha scritto nel messaggio news:420d4827$0$32351$5fc30a8@news.tiscali.it... > 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:
<2NnPd.879320$35.33389551@news4.tin.it>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!proxad.net!213.200.89.82.MISMATCH!tiscali!newsfeed1.ip.tiscali.net!news-out.tin.it!news-in.tin.it!news4.tin.it.POSTED!not-for-mailReferences:
<Z7vOd.863592$35.32894425@news4.tin.it> <420d4827$0$32351$5fc30a8@news.tiscali.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!news-out.tin.it!news-in.tin.it!news4.tin.it.POSTED!not-for-mail From: "Giorgio" <internetnostop@aliceposta.it> Newsgroups: free.it.visual-basic References: <Z7vOd.863592$35.32894425@news4.tin.it> <420d4827$0$32351$5fc30a8@news.tiscali.it> Subject: Re: Inserire dati da form in celle Excel Lines: 68 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 X-RFC2646: Format=Flowed; Response Message-ID: <2NnPd.879320$35.33389551@news4.tin.it> Date: Sat, 12 Feb 2005 13:46:38 GMT NNTP-Posting-Host: 82.56.32.253 X-Complaints-To: "Please send abuse reports to abuse@tin.it and technical notifications to newsmaster@tin.it" X-Trace: news4.tin.it 1108215998 82.56.32.253 (Sat, 12 Feb 2005 14:46:38 MET) NNTP-Posting-Date: Sat, 12 Feb 2005 14:46:38 MET Organization: TIN