VBA Private Sub for all sheets

[BrainDiseasee]

Hello,

I have a private sub i am using in a template style sheet, goal is to be able to essentially duplicate this "Template" worksheet and apply unique title and information to the new sheet name. I have all of that down.
Here is my problem i have two TextBox's from the developer tab each one has a private sub in the sheet to display the data entered into a cell on another sheet called "Master_Data". Here is the code, i am needing a solution on how to have this apply to each sheet or if i can do something like "If ws.Name <>" to limit what sheets dont need this. Anyway below is the code and help would awesome, thanks!!!!

Option Explicit

Private Sub TextBox1_Change()
Sheets("Master_Data").Range("W9").Value = TextBox1.Value
End Sub

Private Sub TextBox2_Change()
Sheets("Master_Data").Range("W10").Value = TextBox2.Value
End Sub

 

[Bosquedeguate]

My suggestion is rather than having this code and textbox controls on each worksheet. Have your code and controls functioning at the Workbook level.

I have a test Workbooks where I pop-up the following UserForm when you are on the Master_Data sheet or any other applicable sheet.
When the form is activated for Master_Data, the ComboBox (Size selection) and Go Live Date text box are disabled.
If on another applicable sheet the Start By Date is disabled and the ComboBox and Go Live Date text box are enabled.

Update button, likewise, will be a function of which worksheet is active.
If on a worksheet other than "Master_Data" the Update button will save the values of the first 2 controls to Master Data Cells W9 and W10
if on the "Master_Data" sheet the value of the 3rd control will be saved to the active sheet (Cell? TBD).

The code is all in the form code for the controls.

 

[BrainDiseasee]

Thanks for your help, i was thinking about this last night except i'm not super familiar with building the user forms.

 

[BrainDiseasee]

Is it possible to share a copy of this file with me so i can try to replicate the example?

 

[Fluff]

i'm not super familiar with building the user forms.

Have a look here VBA UserForm - A Guide for Everyone - Excel Macro Mastery

 

[Bosquedeguate]

Is it possible to share a copy of this file with me so i can try to replicate the example?

Here is a link to my test code. Please keep in mind this is not by any means a complete and working Workbook.
I it primarily implements a non-modal dialog box with 5 controls on it (A ComboBox, 2 TextBoxes (and a couple of buttons not fully implemented).
It is just to give you an idea how you might go about implementing your project.
I hope this helps.

BrainDisease.XLSM

 

[BrainDiseasee]

Thanks, i can see what this is doing and after some tweaking i can get this functional. I really appreciate all the help. Thank you again!