I have a project and a column is formatted for Date like (“A1:A200”) or more
I like when I select any cell from A1 to A 200 to have my calendar form to pop up so that I can pick the desired date and pass it to that cell.
So far I can do this for a single cell or using the OR statement on my code below I can use it for a few more cells
Any help please?
Thanks
Teoant
# Private Sub Worksheet_SelectionChange(ByVal Target as Range)
If Target. Address = "$B$6" Then
‘If Target.Address = "$B$6" Or Target.Address = "$B$10" Or Target.Address = "$B$30" Then
'Is it possible to use a single Cell from a range like ("$B$5:$B$200") for Target. Address
'Instead of a single cell address???
UserForm2.Show
End If
End Sub