Form option buttons not working

[lacogada]

'   Transfers Amount
    If OptionButton1 Then Cells(Nextrow, 4) = TextBox4.Value
    If OptionButton2 Then Cells(Nextrow, 5) = TextBox4.Value

Problem is with OptionButton2

OptionButton2 is inputting TextBox value to col 4 and col 5.

As if OptionButton1 does not get turned off when I select OptionButton2.

Both option buttons are within a frame on a form.

OptionButton1 works correctly.

 

[bertie]

If you place a frame on a form then insert option buttons inside the frame this would make them mutually exclusive, i.e., when you select on the other is deselected.

If you right click the option buttons and select Properties you can assign a GroupName which does the same thing.

If you mean to clear the cell which is populated by the deselected button you would need something like:

[COLOR=green]'  Transfers Amount[/COLOR]
   If OptionButton1 Then
      Cells(Nextrow, 4) = TextBox4.Value
      Cells(Nextrow, 5) = ""
   [COLOR=darkblue]End[/COLOR] If
    
   If OptionButton2 Then
      Cells(Nextrow, 5) = TextBox4.Value
      Cells(Nextrow, 4) = ""
   [COLOR=darkblue]End[/COLOR] If

 

[lacogada]

Thanks Bertie ...... your code fixed it.

.....and thanks for the tip about the "properties-group".