$$Excel-Macros$$ Re: Daniel -- calendar pop-up

t; From: excel-macros@googlegroups.com [mailto:excel- > mac...@googlegroups.com] On Behalf Of Lynn > Sent: mardi 21 juillet 2009 18:14 > To: MS EXCEL AND VBA MACROS > Subject: $$Excel-Macros$$ Re: Daniel -- calendar pop-up > > > any help?? > > On Jul 7, 8:55 pm, Lynn wrot

$$Excel-Macros$$ Re: Daniel -- calendar pop-up

any help?? On Jul 7, 8:55 pm, Lynn wrote: > error --> missing MS calendar control 8.0 > pls help > > Thanks > > On Jul 7, 3:45 am, y2 kx wrote: > > > > > Hello Mr.CA Narendra Ashara, > > Try this link very simple.. > > >http://sudhirsunil.blogspot.com/2009/01/excel-pop-up-calendar-add-in >

$$Excel-Macros$$ Re: Daniel -- calendar pop-up

error --> missing MS calendar control 8.0 pls help Thanks On Jul 7, 3:45 am, y2 kx wrote: > Hello Mr.CA Narendra Ashara, > Try this link very simple.. > > http://sudhirsunil.blogspot.com/2009/01/excel-pop-up-calendar-add-in > >

$$Excel-Macros$$ Re: Daniel -- calendar pop-up

Hello Mr.CA Narendra Ashara, Try this link very simple.. http://sudhirsunil.blogspot.com/2009/01/excel-pop-up-calendar-add-in.html *Calender **is available in all workBooks.* On Mon, Jul 6, 2009 at 9:59 PM, CA NARE

$$Excel-Macros$$ Re: Daniel -- calendar pop-up

Now, if you want to use it with every workbook, it is slightly different. You'll have to create the userform in your personal.xls (or personal.xlsb) file. In a standard module of the personal.xls file, paste the macro : Sub OpenCalendar() frmCalendrier.Show End Sub Use the following macro to

$$Excel-Macros$$ Re: Daniel -- calendar pop-up

Hi. First create a userform and put a control calendar upon it. There are 3 macros in the userform module : At initialization : Private Sub UserForm_Initialize() If IsDate(ActiveCell.Value) Then Calendar1.Value = ActiveCell.Value Else Calendar1.Value = Date End If En