Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Visual Basic > VB 6 Visual Basic 6 > Beginning VB 6
|
Beginning VB 6 For coders who are new to Visual Basic, working in VB version 6 (not .NET).
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Beginning VB 6 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old June 28th, 2007, 01:54 AM
Registered User
 
Join Date: Jun 2007
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default linking information to another sheet and save it

I have a sheet with hours per week. Every week an efficientie is calculated with the hours in the budget and the hours spent in that week ( weeks are per kolom, in the rows are the subjects). The hours spent in that week are put in a kolom under different subjects. This efficientie has to be placed in an other sheet in a kolom with the weeks under each other. The efficientie changes every week and there for this value has to be saved every time. How can I make this with visual basic?


 
Old June 29th, 2007, 04:55 AM
Registered User
 
Join Date: Jun 2007
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I have already written this, but it doesn't work. Does anyone have tips?
Private Sub Worksheet_Change(ByVal Target As Range)
Var = 16 - Sheets("RENDEMENT").Cells(5, 16)

If Intersect(Target, Range("F55")) Is Nothing Then Exit Sub
Row = [F55] + Var
j = 3
For i = 16 To 68
Sheets("WEEK TOTAAL").Cells(Row, j) = Sheets("RENDEMENT").Cells(5, i)
j = j + 1

End Sub







Similar Threads
Thread Thread Starter Forum Replies Last Post
Open Workbook,Copy Sheet,Move Sheet, Close/Save ptrussell2009 Excel VBA 0 June 13th, 2008 02:28 PM
How do I save Information? medp Visual Basic 2005 Basics 1 June 12th, 2007 02:36 AM
how to save as an excel sheet azizsaad19 Beginning VB 6 2 May 25th, 2007 09:48 AM
to save datagrid content to a excel sheet josna VB.NET 1 March 4th, 2006 07:10 AM
save Excel spread-sheet to SQL Server ybao Classic ASP Databases 1 July 12th, 2004 03:02 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.