VBA use value of option button to change dropdown selection

[LL1300]

Hello all,

I have an option button, that when checked off will cause a dropdown form to select the option for 0. The cell links are on another sheet in the workbook.

My option button cell link when checked will say TRUE, and the dropdown would say 0.

I'm new to macros, so any help would be appreciated. Here's what I have so far:

Sub Escrow_Button()
Worksheets("Data").Activate
If Range("AA1").Value = True Then
Range("U1").Value = 0
End If
End Sub

Please let me know if this is possible.

Thanks so much!

 

[vw412]

More detail about your worbook. What sheet is the option button on? What sheet do you want to affect with the option button? Is the dropdown a Data Validation selection list? What cell is it associated with? What are the other options on the dropdown? Is the code you show above working? More questions possible but start with these.

 

[LL1300]

Hey! Thanks for answering.

Not sure how but it somehow decided to work.

Thanks again!