I have Calendar Control 10. It allows selecting only one day, too. You
could add two Textbox controls for getting the first and last days of a
range. With the following code, whatever date is highlit on the
Calendar Control will appear in the TextBox when the clicks on the
TextBox.

Private Sub TextBox1_Enter()
TextBox1.Value = Calendar1.Value
End Sub

Private Sub TextBox2_Enter()
TextBox2.Value = Calendar1.Value
End Sub

Hth,
Merjet