UserForm Help

[cboyce44]

I have 5 data entry userforms in an excel sheet. I have the first UserForm labeled "CalibrationMainForm" that has a Save button that opens up another form. On this form are 2 Option Buttons labeled "OptButtonCalAF" and "OptButtonCalAL". As seen below:

At the end of the 3rd UserForm "ArtifactNom" there is another "Save" button. When the operator presses "Save" on this particular form, I would like either the AFRoughnessResults UserForm to open if user had selected "As Found" option button from CalibrationMainForm or open ALRoughnessResults UserFrom if user had selected "As Left" option button from CalibrationMainForm.

Here is a list of the UserForms I have:

Thank you for all of your help.

 

[DanteAmor]

When the operator presses "Save"

Try:


If you have not closed the userform CalibrationMainForm then, in save button

if CalibrationMainForm.OptButtonCalAF = true then
  AFRoughnessResults.show
elseif CalibrationMainForm.OptButtonCalAL = true then
  ALRoughnessResults.show
end if

 

[cboyce44]

What if I do have "CalibrationMainForm" closed already?

 

[DanteAmor]

What if I do have "CalibrationMainForm" closed already?

The values in the userform controls are in memory while the userform is open, when you close the userform, with the unload statement, then the memory is cleared and the values are lost, in this case you would not know which option button was selected.
If you still want to close the userform, then when you close it you must pass the values to a cell, to later recover those values from the cells, but this is more complicated.

 

[cboyce44]

Okay. Thanks! I will try it the easy way then! lol