Attached is the slim version of the WB with the data...
Posts by av8tordude
-
-
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
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.
-
-
There are 2 parts to my request. Which part is not practical?
-
Out of curiousity, is it normal for someone to accept a request not actively work on it? Hence why I posted in a free forum. I only assume GCExcel was not interested.
-
I haven't received a response to my request. Can I receive help with my request?
-
the form has some code. To help understand the request better, do the following...
1. fill the textboxes, click enter to fill the listboxes
2. Repeat 2 more times so there are more items in the list box.
Once finish, i would like to click the submit button to accomplish my original request. -
Can someone assist with a VBA code that will do two (2) things
1. loop through a Userform Listbox to insert Columns 1 (Quantity), 2 (Price), 3 (Broker Fee) into the spreadsheet column T - AH of the Active Row.
2. Re-number the Lot # column to the correct numerical sequence when a row is deleted.
-
See instructions below... Extra $25.00 if completed within 24 hours upon acceptance. Payment via PayPal.
On the sheet…
- The calendar dates should update based on the sheet name (Sheet name will be named in years (i.e. 2019)
The Calendar…
- Each Label date boxes should display the dates corresponding to the selected month
- If there are no dates in the label date boxes, the label and textboxes should be grayed out
- Highlight textbox base on the current date
- Highlight each label date box if there are schedule events entered for each date
- Display the times in the textbox if there is a schedule event
- If I select a different month, update calendar dates, colors themes and scheduled times
When I click a date…- Highlight the textbox based on the current time. (i.e. if current time is 10:30, highlight the textbox next to 09:00 – 10:00 label)
- display then events in the correct base on their time slots
Time slots…
- When I enter information a time slots, display the time slot in the calendar
Enter Button
- When I click the Enter Button, Insert the information to their respected time slot (Column J-N)
- Insert the time zone displayed vertically in the calendar
- Insert the time slots in the respective datesOn the sheet…
- The calendar dates should update based on the sheet name (Sheet name will be named in years (i.e. 2019)
- The Calendar…
- Each Label date boxes should display the dates corresponding to the selected month
- If there are no dates in the label date boxes, the label and textboxes should be grayed out
- Highlight textbox base on the current date
- Highlight each label date box if there are schedule events entered for each date
- Display the times in the textbox if there is a schedule event
- If I select a different month, update calendar dates, colors themes and scheduled times
- When I click a date…
- Highlight the textbox based on the current time. (i.e. if current time is 10:30, highlight the textbox next to 09:00 – 10:00 label)
- display then events in the correct base on their time slots
- Time slots…
- When I enter information a time slots, display the time slot in the calendar
- Enter Button
- When I click the Enter Button, Insert the information to their respected time slot (Column J-N)
- Insert the time zone displayed vertically in the calendar
- Insert the time slots in the respective dates
No formulas! Very Important! Completed work should be Pm'ed
