Posts by StevegSmith

Re: link a page in a multipage userform to a worksheet

Quote from StevegSmith;796286

Hi,
I would like to link each page in a multipage userform to different worksheet. How would I go about doing this?
I have 4 worksheets that are order forms and I created the multipage userform to aid users to fill out the order forms and place orders. I have been searching and trying different change events but, no luck in getting it to work.
Thank you,
Steve

Thank you! I will give it a shot. Thank you for taking the time to look at my problem:)
Steve

Hi,
I would like to link each page in a multipage userform to different worksheet. How would I go about doing this?
I have 4 worksheets that are order forms and I created the multipage userform to aid users to fill out the order forms and place orders. I have been searching and trying different change events but, no luck in getting it to work.
Thank you,
Steve

Hi All,
I'm fairly new too VBA, but learning. Is there a better way to allow only one checkbox to be checked within a frame on my userform? Below is what I have but I have many Frames with check boxes to code.

Private Sub CheckBox73_Click()If Me.CheckBox73.Value = True Then
Sheets("TBIN").CheckBox11 = True
If Me.CheckBox73.Value = True Then
Me.CheckBox74.Value = False
Sheets("TBIN").CheckBox12 = False
Me.CheckBox63.Value = False
Sheets("TBIN").CheckBox13 = False
Me.CheckBox65.Value = False
Sheets("TBIN").CheckBox14 = False
Me.CheckBox66.Value = False
Sheets("TBIN").CheckBox15 = False
Me.CheckBox67.Value = False
Sheets("TBIN").CheckBox16 = False
Me.CheckBox75.Value = False
Sheets("TBIN").CheckBox17 = False
Me.CheckBox68.Value = False
Sheets("TBIN").CheckBox18 = False
Me.CheckBox64.Value = False
Sheets("TBIN").CheckBox19 = False
Me.CheckBox70.Value = False
Sheets("TBIN").CheckBox20 = False
Me.CheckBox69.Value = False
Sheets("TBIN").CheckBox21 = False
Me.CheckBox71.Value = False
Sheets("TBIN").CheckBox22 = False
Me.CheckBox72.Value = False
Sheets("TBIN").CheckBox23 = False
End If
End If
End Sub