Firstly want to apologise - after years of using formulas, I've only started using (or attempting) to use macros for the first time a few days ago, so my explanations may be a little rusty, but I'll do my best.
I'm creating a form in Excel, for relocations of a device.
The form has 4 Option Buttons (ActiveX Control) in 2 categories - 2 YES and 2 NO buttons in total.
For 1 of the categories, I'm asking the customer I'm asking the customer, if they require Same Day Delivery, with the date of collection asked earlier in the form.
If they state YES using the Option Button, Cell D24 populates the same date listed earlier in Cell D17 (for the collection). This works fine. However, if the date is then updated in Cell D17, the date/data in Cell D24 does not automatically update with these changes. You have to press the "NO" button to clear Cell D24, and then press the "YES" button, to repopulate the accurate information from D17.
The code used is:
- Code: Select all
Private Sub YES_Date_Click()
If Sheets("Mancourt Form").YES_Date.Value = True Then
Range("D24").Value = Range("D17").Value
End If
End Sub
Any help would be greatly appreciated. Thank you.