Re: Calendar Control Active X 10 problem

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Dan Artuso (dartuso_at_NOSPAMpagepearls.com)
Date: 05/26/04 

Date: Wed, 26 May 2004 11:16:40 -0400

Hi,
Try:
Forms!Form1!Text0 = Calendar3.Value

HTH
Dan Artuso, MVP

"DubboPete" <pcastlehouse@"nospam"ozemail.com.au> wrote in message news:GJ0tc.134$rE.6799@nnrp1.ozemail.com.au...
> Hi Kerry,
>
> Thanks, I found the event 'click', and added the code... however when
> clicking the calendar control the code produces Run-time error '424' -
> object required
>
> any clues?
> tia
> DubboPete
>
> > Simply add:
> >
> > Private Sub Calendar3_Click()
> > Form1.Text0 = Calendar3.Value
> > End Sub
>
>

Relevant Pages

  • Re: Automatic saving and closing
    ... save the workbook and your users would re-open it prior to making any changes. ... Sub StartOnTime() ... Application.OnTime RunTime, "SaveAndCloseMe",, False ...
    (microsoft.public.excel.programming)
  • RE: Countdown timer
    ... Private Sub Workbook_Open ... This saves and closes the workbook after 2 hrs and 1 minute of inactivity. ... Dim TimeRemaining As Long ...
    (microsoft.public.excel.programming)
  • RE: Message boxes
    ... "Steve the large" wrote: ... Private Sub CommandButton1_Click ... any of them haven't been populated when a command button is clicked to move ...
    (microsoft.public.excel.programming)
  • RE: Mike H - Help
    ... "Tia" wrote: ... HIDE the Calendar until it is used again. ... Private Sub Worksheet_SelectionChange ... What you do is go back to vb editor right click the userform in project ...
    (microsoft.public.excel.worksheet.functions)
  • RE: Message boxes
    ... Private Sub CommandButton1_Click ... Dim TB As Control ... any of them haven't been populated when a command button is clicked to move ...
    (microsoft.public.excel.programming)