D
David
Hi,
I have a user form that pops up when you open the
workbook with three text box inputs and one comman button
("Enter") to populate the text to certain fields. Can
someone please tell me the coding to force the user to
put a yes or no in each textbox before they can exit the
user form in order to advance to the worksheet? If they
try to go on w/out putting the right inputs, I would like
to dispaly a message, like "please provide an answer
first."
Also can you change the name of the userform so that it
doesn't say UserForm1 in the blue box when it pops up in
excel?
Any help is greatly apprecaited. My code is below:
Private Sub CommandButton1_Click()
Worksheets("Allocation").Range("M9").Value = TextBox1.Text
Worksheets("Allocation").Range("M11").Value =
TextBox2.Text
Worksheets("Allocation").Range("M42").Value =
TextBox3.Text
Worksheets("Allocation").Calculate
Unload Me
End Sub
I have a user form that pops up when you open the
workbook with three text box inputs and one comman button
("Enter") to populate the text to certain fields. Can
someone please tell me the coding to force the user to
put a yes or no in each textbox before they can exit the
user form in order to advance to the worksheet? If they
try to go on w/out putting the right inputs, I would like
to dispaly a message, like "please provide an answer
first."
Also can you change the name of the userform so that it
doesn't say UserForm1 in the blue box when it pops up in
excel?
Any help is greatly apprecaited. My code is below:
Private Sub CommandButton1_Click()
Worksheets("Allocation").Range("M9").Value = TextBox1.Text
Worksheets("Allocation").Range("M11").Value =
TextBox2.Text
Worksheets("Allocation").Range("M42").Value =
TextBox3.Text
Worksheets("Allocation").Calculate
Unload Me
End Sub