I want to launch userform A when the user hits the command button on userform B, I already have a macro set up to launch UserForm A and tried adding it to the code but it doesn't work.
This is what I have
What needs to be fixed or is there a way to just launch the other userform without trying to fire macro?
Thanks in advance!
P.S. I asked this same question in another forum, but it hasn't been addressed, so I figured I'd give it a try here.
This is what I have
Code:
Private Sub CommandButton1_Click()
Worksheets("Patient").Range("B9").Value = TextBox1.Value
Worksheets("Patient").Range("B10").Value = TextBox2.Value
Worksheets("Patient").Range("B11").Value = TextBox3.Value
Worksheets("Patient").Range("B15").Value = TextBox4.Value
End Sub
Sub Vanco_Sticker()
Patient_info.Show
End SubWhat needs to be fixed or is there a way to just launch the other userform without trying to fire macro?
Thanks in advance!
P.S. I asked this same question in another forum, but it hasn't been addressed, so I figured I'd give it a try here.
