Hi again!

I have a sheet whith information, when the user push the macro button on the
sheet this form is showing

Load FrmOldEnviroment
FrmOldEnviroment.TextBoxOldEnviroment.Text = ActiveSheet.Range("e"
&_EnviromentRow).Value
FrmOldEnviroment.Show
If FrmNewEnviroment.OptButton1 = True Then
ActiveSheet.Range("e" & EnviromentRow).Value =
FrmNewEnviroment.OptButton1.Caption
ElseIf FrmNewEnviroment.OptButton2 = True Then
ActiveSheet.Range("e" & EnviromentRow).Value =
FrmNewEnviroment.OptButton2.Caption
ElseIf FrmNewEnviroment.OptButton3 = True Then
ActiveSheet.Range("e" & EnviromentRow).Value =
FrmNewEnviroment.OptButton3.Caption
ElseIf FrmNewEnviroment.OptButton4 = True Then
ActiveSheet.Range("e" & EnviromentRow).Value =
FrmNewEnviroment.OptButton4.Caption
End If

With this the user can change the contents of the cell if he want to, my
problem is to make the change happen at the same time as the user push the
next or the finish button on the form. When the macro runs for the first time
no optButtion is chosen, but when the user has chosen one optButton i want to
"clear" the form if its started again.

--
Nil Satis Nisi Optimum