# Posts by av8tordude

• ## Calculate and display result in userform label (15 USD)

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

• ## Calculate and display result in userform label (15 USD)

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))

• ## Calculate and display result in userform label (15 USD)

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")

• ## Calculate and display result in userform label (15 USD)

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

• ## Calculate and display result in userform label (15 USD)

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

• ## Calculate and display result in userform label (15 USD)

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)

• ## Calculate and display result in userform label (15 USD)

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.

• ## Create an message alert - \$15.00

Complete complete... Thank you S.O.

Sorry....USD

• ## Create an message alert - \$15.00

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

• ## VBA code to Sum values in userform - \$25.00

Job Complete...Thank you Trunten

• ## VBA code to Sum values in userform - \$25.00

See instructions

I will send file via PM.

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

Paypal Transaction: 7WE341457F796835N

• ## \$50.00 - Loop through listbox to insert to sheet

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

I sincerely apologies to everyone.

Payment Sent

• ## \$50.00 - Loop through listbox to insert to sheet

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

• ## \$50.00 - Loop through listbox to insert to sheet

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.

• ## \$50.00 - Loop through listbox to insert to sheet

I haven't received a response to my request. Can I receive help with my request?

• ## \$50.00 - Loop through listbox to insert to sheet

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.

• ## \$50.00 - Loop through listbox to insert to sheet

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.

• ## Code Calendar Event - \$50.00 USD

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