Userform Data Entry on multiple sheets

Rthigpen162

New Member
Joined
Jun 18, 2021
Messages
2
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
Hello, this is my first post and I am very new to VBA.

I am trying to make an excel sheet to track production for manufacturing.

I am trying to create a userform that will input operator supplied data (# of parts completed per day) into the correct spot on each sheet for each job we are doing. My current thought process is that I want the Job # combo box to designate which sheet the store the data, then the shift number to specify which column (C, D, or E), then day number to specify which row (3 through 33) and ultimately lock the cell for further editing after the data has been put in rather than allowing for the program to overwrite the cells. Would this be the best way of going about this?

As of right now I have the userform designed and the combo boxes linked to charts to populate their selections as well as the userform.show function connected to a command button.

Any help would be greatly appreciated!!

1624022946018.png
1624022976143.png
 

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.

ranman256

Well-known Member
Joined
Jun 17, 2014
Messages
1,998
the data should be entered into a straight-forward list
JOB#, Date, Shift, PartComplete

this allows you to run analysis on the data (pivot or other) and put it into your special sheet you show.
 

Rthigpen162

New Member
Joined
Jun 18, 2021
Messages
2
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
Do you mean that I should have the user data go into a simple form where I can then send it to my desired sheets?

Thanks for the reply


the data should be entered into a straight-forward list
JOB#, Date, Shift, PartComplete

this allows you to run analysis on the data (pivot or other) and put it into your special sheet you show.
 

Forum statistics

Threads
1,136,787
Messages
5,677,731
Members
419,716
Latest member
MPunt

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top