Recent content by paulmtl

Hi all, I try to run a sample.mdb program and get an error message compile error, can't find project or library ? in the VBA editor Please explain what went wrong ? Thanks in advance,

Hi all, This is my codes in Visual Foxpro, can someone who had knowledge of VFP and VB, helps me to convert to VB. Thanks in advance, CREATE CURSOR crsResult (account C(10),amount N(15,2), percentage N(6,2), ClassCode C(5)) SELECT MyTable INDEX ON Account+ClassCode TAG MyTable && With proper...

Hi all, I started my coding to calculate : account amount classcode percentage 11111 100 AAAAA 0.16 11111 200 AAAAA 0.34 11111 300 AAAAA 0.50 --------------- subtotal 600 11111 100 BBBBB 0.16 11111 200 BBBBB 0.34 11111 300 BBBBB 0.50 --------------- subtotal 600 here is the...

Hi all, How to create the formula to calculate the percentage out of the total in general format can be used all along ? from myExcel.xls account amount classcode percentage 11111 100 AAAAA 0.16 11111 200 AAAAA 0.34 11111 300 AAAAA 0.50 --------------- subtotal 600 11111 100 BBBBB...

Hi PHV, I appreciate that solution in the thread 707-1057331 but I have to copy one by one that formula to each cell, it's taking more times. That's why I need someone to help me to create the codes in VBA in a loop. Thanks again,

Hi all, How to create the formula to calculate the percentage out of the total in general format can be used all along ? from myExcel.xls account amount classcode percentage 11111 100 AAAAA 0.16 11111 200 AAAAA 0.34 11111 300 AAAAA 0.50 --------------- subtotal 600 11111 100 BBBBB...

Hi all, How to create the formula to calculate the percentage out of the total in general format can be used all along ? from mytable.dbf account amount percentage 11111 100 0.16 11111 200 0.34 11111 300 0.50 --------------- subtotal 600 22222 200 0.25 22222 200 0.25 22222 400 0.50...

Hi all, I created a macro16() to copy and paste as you can see below but always copied to the same row means the first row How to correct this macro to copy to second row and so on...? row1 john doe row1 brian die to get : row1 john doe row2 brian die Thanks in advance, the codes by...

Thanks Tony, It works great.

Hi all, How to create the formula to calculate the percentage out of the total in general format can be used all along ? account amount percentage 11111 100 0.16 11111 200 0.34 11111 300 0.50 --------------- 600 22222 200 0.25 22222...

Hi Skip, Perfect to built combo box, I can select 11111 from combo box and how to past that to the new cell ? TIA

In the Excel workbook

Hi all, How to use combo box in the Excel workboot ? empno: 11111 22222 33333 44444 in order to select empno from combo box Thanks in advance

Hi Frederico Fonseca, Here is the first sheet1 need to be fill from sheet2 and sheet3 in the same workbook. sheet1: Bulk Issue Name Coupon Mat Date 1 FORD CREDIT CDA 2 3 4 sheet2 : ISSUE_NAME COUPON MAT_DATE FORD CREDIT CDA 5.96 3-Dec-35 GM US CIE 6.05 27-Jul-09 SHEET3: ACCOUNT...

Hi Frederico Fonseca, I would like to achieve the input cells from one sheet to other sheets for example : sheet 1 has : cell1 to fill in from sheet2 that contains acctnum# as primary key with custname,address,tel . like in the combobox refers as arrays to be built. When the user picks the...