Identify groups and calculate with VBA UserForm

Hi Everyone,

Its my first time using VBA and any sort of coding in general so I have been cracking my head for weeks trying to do this UserForm . I'm wondering if there is anyone here that could help me with it? Any help is appreciated, Thank you in advance!!

I've created a UserForm (Sheet 1 Button: Click me to enter Data ) to key in data into the excel spreadsheet. There is Name(cboName), Product(cboProduct), Date(txtDate) and Quantity(txtQuantity). I would like the last column ( Time Taken ( which is Quantity*standard time ) ) to be automatically calculated in the excel worksheet as the rows of data is added. The Data reference(Table3) for the standard time is in another sheet ( Sheet2 ) and to get the standard time, I would have to identify first from which group does the product lies, as the standard time is tied to the group. I am able to do it with excel formula ( IFS ) quite easily but I would like to do it with VBA so whoever uses it wouldn't accidentally delete or change the formula. Is there a way to do so? I'll attach the screenshot of the excel formula below.

I have attached my Excel worksheet here, the IFS formula that I tried is also in the worksheet. Thanks!!

I'm sorry I didn't know that I'm not allowed to post on other Forums, but I posted on 2 others Forums yesterday. I'll attach the links below. If this causes any inconvenience, do let me know so I can take down the thread in other Forums!
Link 1 :"stackoverflow.com/questions/70285615/search-data-to-calculate-the-quantity-with-vba-userform"
Link 2 :"mrexcel.com/board/threads/search-data-and-calculate-with-vba-userform.1189762/"

*I removed the www and https because it seems like I wouldn't be able to upload with it

Hi Justin

This will give you an idea...Your file had no Userform or any code so I had to improvise...
I also changed your sheet setup...Ideally always start in [A1] of worksheets...
To much code to post...

The Exit Button just hides the Userform...Was for testing only...

Press Alt F9 - takes you to Project Window
Select Developer from Ribbon, press Visual Basic -takes you to Project Window

PS - Forgot to clear TextBox4...Add red snippet

Please Login or Register  to view this content.

With reference to your other post here

The reconciliation of Stylists hours based on date...How often do you extract...Is it daily or monthly...Does the recon get cleared when new recon is wanted...
Does your register get cleared every month or is it continuous...
Is the stylist list for extraction based on your existing database or is it only those that have entries in register...

From this other post you have a separate userform...I would make use of the same Userform...Just adding date selection and Stylist name and then doing extraction...

PS...I noticed an error in code above

remove red snippet...

Please Login or Register  to view this content.

Anyway...Here is an amended version with Time Extraction...

JustoneE

May I ask why you would want to separate the register into Months when all you can do is extract any required data via your Userform Interface...
I would have 1 Register Tab & 1 Extraction Tab - With headings Jan - Dec...When extracting, it extracts to required Month...One could also just extract monthly data for your Monthly Chart...1 Tab for the 12 charts...
At year end I would make a copy of Register Tab ... name it Register 2021 and clear Register Tab for new year...

Anyway...just my two cents...If you prefer to go your route then I suggest you setup your file in your required layout...This is going to take alot of coding so you might have to do it in different steps with different threads...

I have just tried on the Userform and I couldn't seem to let it calculate, Could you advice me on it?

The file in above post 7 had some data already captured...On userform at bottom you are able to
Select Month...in this case Dec
Select Stylist...On this selection, the total time for month is shown in Total Time box

Untitled.png