View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Peggy Peggy is offline
external usenet poster
 
Posts: 47
Default Form query in VBA

Dear FSt1,
Unfortunatley, the author of the form cannot be reached. The Month is not
viewing correctly in the form. Here is the macro that has been written. Do
you need more info?
Private mChoice As Variant 'Holds the choice of the user

Private Sub BCancel_Click()
mChoice = False 'User cancelled
Me.Hide
End Sub

Private Sub Calendar2_Click()
mChoice = Calendar2.Value
Me.Hide
End Sub

Public Sub Display(ByVal Target As Range)
'Make sure that we received only one cell
Set Target = Target(1)

If IsDate(Target.Value) Then
mChoice = Target.Value
Else
mChoice = Date
End If
Calendar1.Value = CDate(mChoice)
Me.Show
End Sub

Public Property Get GetChoice() As Variant
GetChoice = mChoice
End Property

Private Sub Calendar1_Click()

End Sub

Private Sub UserForm_Click()

End Sub

Any ideas how I can fix this so the months of the year are showing through
properly? Currently I have 12 January's showing.

"FSt1" wrote:

hi
see someone. (the someone you got the calendar from)

If someone is not available, supply more info.

Regards
FSt1

"Peggy" wrote:

I have copied a great pop up calendar from someone else and have got the pop
up calendar to work. However, the months and dates do not appear correctly.
Please could you tell me where I need to look to check this information.

Many thanks,
Peggy