Posts by av8tordude

Advertisement fee sent. Thanks Trunten

I would like individual vba scripts that can accomplish specific task . Instruction on worksheet.
I will be happy to pay advertisement fee once accepted.

Thank you

Project Completed. Thank you Truten

Advertisement fee paid! I look forward to any question you may have. thank you.

I would like a vba script that will sum the values in column Q that fall on the days in column DA and within the hours in column DD. Also, I would like to be able to look back by either number of days or number of trade entries.

For example,

If I want to look back 10 dates from the last entry (5/10), the lookback should be to 4/28 (Row 41).

If I want to look back 10 Entries, the lookback should be to Row 57

I think the workbook should be self-explanatory of the final results. Note: the values are the actual sums to make sure you get the same output

Since this board has not been active in awhile, I will be happy to pay the advertisement fee once someone accept.

Attached is the slim version of the WB with the data...

I unprotected the sheet and unrestricted the scroll area, however I getting the error (type mismatch) at the line of code... BuyTot = BuyTot + (x(1, i) * x(1, i + 1))

Received an error running the code, but this is related to 2 things

1. sheet protection with password

2. scroll area (i.e. ScrollArea = "A:S")

Perfect...Thank you! Greatly appreciate your help C.

I need to calculate the data on the selected row

Quote from KjBox

CurrentRegion is a block of cells without empty rows or columns, Rows(5) is the 5th row of that block.

So all the data in the 5th row of the current region starting in cell T4 gets loaded into array x

Can you explain this line of code? I'm trying to integrate the code into my workbook. In the example WB, I place the data in the columns to match my main WB, however, there are multiple rows with data. Ii would want to calculate the data on the selected row. If the selected row in row 15, calculate the data in row 15 only.

x = [t4].CurrentRegion.Rows(5)

I need a VBA code to display the results in a label for the selected row. The example book has only one row, however the code will be used in a workbook that has multiple rows There are calculations (with formulas) inserted in the sheet, however this is only to help understand how to produce the final result in the label. This will not be in part of the sheet.

Complete complete... Thank you S.O.

Sorry....USD

I have a calendar setup on a worksheet (Column BS6 to CC372). I would like a vba code that display a message alerting me of upcoming events for the current week.

For example, from 06/10 - 06/13, I have place "test" in the dates for this week as upcoming events. When this sheet is activated, the code should check the dates that fall within the current week for schedule events. If so, display a message box “ You have upcoming events”.

If no events are scheduled within a week, then display a message should says “No upcoming events”.

This code ideally should be placed in the Worksheet.Activate module.

finish project should be sent via pm.

Ozgrid Paypal transaction: 7RE14879JP648001E

Job Complete...Thank you Trunten

See instructions

I will send file via PM.

When task is completed, file must be sent via pm.

Paypal Transaction: 7WE341457F796835N

Project Complete. Exactly as i expected. Thank you GCExcel.

I sincerely apologies to everyone.

Payment Sent

There are 2 parts to my request. Which part is not practical?