Click here to Skip to main content
12,294,775 members (64,776 online)

Visual Basic

 
QuestionDebug user control in VB6.0 ? Pin
Member 24584678-Jan-13 22:38
memberMember 24584678-Jan-13 22:38 
AnswerRe: Debug user control in VB6.0 ? Pin
ChandraRam17-Jan-13 20:08
memberChandraRam17-Jan-13 20:08 
QuestionHow make DOWNLOADER in VB 2010 ? Pin
radoslaw1238-Jan-13 7:21
memberradoslaw1238-Jan-13 7:21 
AnswerRe: How make DOWNLOADER in VB 2010 ? Pin
GuyThiebaut8-Jan-13 21:53
memberGuyThiebaut8-Jan-13 21:53 
GeneralRe: How make DOWNLOADER in VB 2010 ? Pin
radoslaw1239-Jan-13 0:36
memberradoslaw1239-Jan-13 0:36 
GeneralRe: How make DOWNLOADER in VB 2010 ? Pin
GuyThiebaut9-Jan-13 0:40
memberGuyThiebaut9-Jan-13 0:40 
QuestionIOException was Unhandled Pin
jankevint7-Jan-13 14:37
memberjankevint7-Jan-13 14:37 
AnswerRe: IOException was Unhandled Pin
Dave Kreskowiak7-Jan-13 18:08
mvpDave Kreskowiak7-Jan-13 18:08 
GeneralRe: IOException was Unhandled Pin
jankevint7-Jan-13 21:52
memberjankevint7-Jan-13 21:52 
AnswerRe: IOException was Unhandled Pin
Richard MacCutchan7-Jan-13 22:26
mvpRichard MacCutchan7-Jan-13 22:26 
GeneralRe: IOException was Unhandled Pin
jankevint7-Jan-13 23:18
memberjankevint7-Jan-13 23:18 
GeneralRe: IOException was Unhandled Pin
Richard MacCutchan7-Jan-13 23:31
mvpRichard MacCutchan7-Jan-13 23:31 
AnswerRe: IOException was Unhandled Pin
Mike Meinz22-Jan-13 3:15
memberMike Meinz22-Jan-13 3:15 
GeneralTo calculate with two - three & four criteria multiple worksheet in summary sheet Pin
atulkhandekar3-Jan-13 21:42
memberatulkhandekar3-Jan-13 21:42 
Hi Friend's, I am using excel 2007. In my file 6 sheets. 4 sheets is data record & 1 sheet is recorder sheet & monthly.
Data record sheet name is : FY_2009, FY_2010, FY_2011, FY_2012 & FY_2013.
In all above sheet :
Part numbers mentioned in column "C2:C60000"
Quantity in column "D2:D60000"
Branch in column "G2:G60000"
Month in column "H2:H60000"
Year in column "I2:I60000"
In some sheet record range in differ. Some sheet upto row 50000 & some sheet upto 38000 but field name partnumber quantity, branch, month & year in same column.

1st case : In recorder sheet i have calculate how many quantity sold part number wise as well as in particular year & branch wise. (Location of part number in A2:A10000 column & Year mention in column F2:J2 (i.e. 2009, 2010,2011,2012, 2013)

2nd case : In column L2 mentioned year (i.e. 2012) & L2:Q2 mentioned branch.(i.e. "HGN", "NGP", "AKL", "AMRT", "CHN", "YTMAL")
How many quantity sold branch wise in 2012 year.

3rd case : In column R2 mentioned branch (i.e. "HGN",   & R2:W2 mentioned years 2009, 2010, 2011, 2012, 2013)
How many quantity sold from one branch in year wise.

In monthly sheet i have calculate how many quantity sold part number wise as well as in particular month & year wise.
In monthly sheet location of :
Part number in : "B1" cell.
Months : 1,2,3 ... so on upto 12 in location is B2:M2.
Years : "A4:A8

Presently, i have calculate through excel formula but calculation is slow due to thousand of data records
& thousand of formula. And it will take very long time.

Now i required to calculate through vba micro to speed up our work.
In view of the above kindly let me know.
Note: I am not familiar with VBA.
AnswerRe: To calculate with two - three & four criteria multiple worksheet in summary sheet Pin
Eddy Vluggen4-Jan-13 22:48
memberEddy Vluggen4-Jan-13 22:48 
GeneralRe: To calculate with two - three & four criteria multiple worksheet in summary sheet Pin
atulkhandekar7-Jan-13 1:46
memberatulkhandekar7-Jan-13 1:46 
AnswerRe: To calculate with two - three & four criteria multiple worksheet in summary sheet Pin
Eddy Vluggen7-Jan-13 1:57
mvpEddy Vluggen7-Jan-13 1:57 
GeneralRe: To calculate with two - three & four criteria multiple worksheet in summary sheet Pin
Richard MacCutchan7-Jan-13 6:39
mvpRichard MacCutchan7-Jan-13 6:39 
GeneralRe: To calculate with two - three & four criteria multiple worksheet in summary sheet Pin
Shailesh Shah12-Jan-13 19:20
memberShailesh Shah12-Jan-13 19:20 
Questionwhich method I should go with Pin
demo 22-Jan-13 19:54
memberdemo 22-Jan-13 19:54 
AnswerRe: which method I should go with Pin
Eddy Vluggen4-Jan-13 22:51
memberEddy Vluggen4-Jan-13 22:51 
Questionvb6 with ms access2007 database Pin
tuticorinmano2-Jan-13 9:58
membertuticorinmano2-Jan-13 9:58 
AnswerRe: vb6 with ms access2007 database Pin
David Mujica2-Jan-13 10:26
memberDavid Mujica2-Jan-13 10:26 
GeneralRe: vb6 with ms access2007 database Pin
tuticorinmano2-Jan-13 12:49
membertuticorinmano2-Jan-13 12:49 
QuestionShould be simple: incompatible types Pin
AndreFratelli1-Jan-13 7:44
memberAndreFratelli1-Jan-13 7:44 
AnswerRe: Should be simple: incompatible types Pin
AndreFratelli2-Jan-13 0:27
memberAndreFratelli2-Jan-13 0:27 
GeneralRe: Should be simple: incompatible types Pin
GuyThiebaut7-Jan-13 22:34
memberGuyThiebaut7-Jan-13 22:34 
Questiondatagrid in vs 2012 Pin
jenkinsdjj30-Dec-12 20:22
memberjenkinsdjj30-Dec-12 20:22 
AnswerRe: datagrid in vs 2012 Pin
Richard MacCutchan30-Dec-12 22:29
mvpRichard MacCutchan30-Dec-12 22:29 
GeneralRe: datagrid in vs 2012 Pin
jenkinsdjj31-Dec-12 0:40
memberjenkinsdjj31-Dec-12 0:40 
QuestionGetting innertext of HTML with </ br> tag between words Pin
Stonesteel26-Dec-12 22:57
memberStonesteel26-Dec-12 22:57 
AnswerRe: Getting innertext of HTML with </ br> tag between words Pin
Dave Kreskowiak27-Dec-12 8:49
mvpDave Kreskowiak27-Dec-12 8:49 
GeneralRe: Getting innertext of HTML with </ br> tag between words Pin
Stonesteel27-Dec-12 21:04
memberStonesteel27-Dec-12 21:04 
GeneralRe: Getting innertext of HTML with </ br> tag between words Pin
Dave Kreskowiak28-Dec-12 4:41
mvpDave Kreskowiak28-Dec-12 4:41 
Questionthreading impliment Pin
Michael Hulak25-Dec-12 17:58
memberMichael Hulak25-Dec-12 17:58 
AnswerRe: threading impliment Pin
Dineshshp25-Dec-12 18:32
memberDineshshp25-Dec-12 18:32 
AnswerRe: threading impliment Pin
Eddy Vluggen26-Dec-12 12:16
memberEddy Vluggen26-Dec-12 12:16 
QuestionHow to read list of local and network printers Pin
KASR125-Dec-12 7:21
memberKASR125-Dec-12 7:21 
AnswerRe: How to read list of local and network printers Pin
Eddy Vluggen25-Dec-12 8:30
memberEddy Vluggen25-Dec-12 8:30 
GeneralRe: How to read list of local and network printers Pin
KASR126-Dec-12 3:38
memberKASR126-Dec-12 3:38 
GeneralRe: How to read list of local and network printers Pin
Eddy Vluggen26-Dec-12 11:58
memberEddy Vluggen26-Dec-12 11:58 
GeneralRe: How to read list of local and network printers Pin
KASR126-Dec-12 23:15
memberKASR126-Dec-12 23:15 
GeneralRe: How to read list of local and network printers Pin
Eddy Vluggen27-Dec-12 4:28
memberEddy Vluggen27-Dec-12 4:28 
GeneralRe: How to read list of local and network printers Pin
KASR127-Dec-12 7:26
memberKASR127-Dec-12 7:26 
GeneralAdding an email notification module to my application. Pin
KismetGerald24-Dec-12 13:01
memberKismetGerald24-Dec-12 13:01 
GeneralRe: Adding an email notification module to my application. Pin
Richard MacCutchan24-Dec-12 23:07
mvpRichard MacCutchan24-Dec-12 23:07 
GeneralRe: Adding an email notification module to my application. Pin
KismetGerald25-Dec-12 0:09
memberKismetGerald25-Dec-12 0:09 
GeneralRe: Adding an email notification module to my application. Pin
Richard MacCutchan25-Dec-12 21:01
mvpRichard MacCutchan25-Dec-12 21:01 
Questionvbs - text inputs uploaded to web Pin
oceaniana24-Dec-12 12:25
memberoceaniana24-Dec-12 12:25 
QuestionThrowing run time error while saving the record. Pin
Member 786176324-Dec-12 2:11
memberMember 786176324-Dec-12 2:11 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.


Advertise | Privacy | Mobile
Web02 | 2.8.160525.2 | Last Updated 26 May 2016
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid