Go Back   TechArena Community > Software > Windows Software
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



Way to insert a Date Picker in MS Excel cell

Windows Software


Reply
 
Thread Tools Search this Thread
  #1  
Old 11-12-2010
Member
 
Join Date: Oct 2010
Posts: 62
Way to insert a Date Picker in MS Excel cell
  

I am having an Excel Workbook and this workbook has very much important data which must need a date to verify them. So I thought to insert the automatic date picker which will release the headache of checking the date for the data again and again. Can anybody tell me how can I insert the date picker in the Excel cell?

Reply With Quote
  #2  
Old 11-12-2010
Member
 
Join Date: May 2008
Posts: 979
Re: Way to insert a Date Picker in MS Excel cell

I suggest you to add a DateTimePicker control in your excel worksheet at the range. For adding such tool you have to install the Microsoft.Office.Tools.Excel.v9.0 (in Microsoft.Office.Tools.Excel.v9.0.dll). Once your machine has this version then it won't be much hard to add datetimepicker tool in your worksheet. This tool would be in Microsoft.Office.Tools.Excel.Controls.DateTimePicker.
Reply With Quote
  #3  
Old 11-12-2010
Member
 
Join Date: Nov 2008
Posts: 1,192
Re: Way to insert a Date Picker in MS Excel cell

According to me you have to Add a new DateTimePicker control to the worksheet which is the perfect one for purpose of what you are trying to have on your excel sheet. Here I have provided the methods which you can use to add datetime picker.
  • AddDateTimePicker(Range, String) : Adds a new DateTimePicker control to the worksheet at the range specified.
  • AddDateTimePicker(Double, Double, Double, Double, String) : Adds a new DateTimePicker control to the worksheet in the specified size and location.
Reply With Quote
  #4  
Old 11-12-2010
Member
 
Join Date: Nov 2008
Posts: 1,259
Re: Way to insert a Date Picker in MS Excel cell

Following are the exceptions that you have to use whenever you use the datetimepicker in your excel sheet. Actually sometime this exceptions saves your work.
  • ArgumentNullException : Name or Range arg is a null which is just nothing in Visual Basic, or Name arg has zero length.
  • ControlNameAlreadyExistsException : A control with the same name is already in the ControlCollection instance.
  • InvalidRangeException : For controlling the specified range. You won't be able to use Multi-area ranges. Specifies range must be on the same worksheet as the ControlCollection instance.
Reply With Quote
Reply

  TechArena Community > Software > Windows Software
Tags: , , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Way to insert a Date Picker in MS Excel cell"
Thread Thread Starter Forum Replies Last Post
Is it possible to have function which can insert date automatically in Excel De-Dg MS Office Support 10 25-02-2012 10:56 AM
Is it possible to insert Outlook Message in Microsoft Excel cell EveryWer MS Office Support 2 17-02-2012 07:52 PM
How to insert a paragraph break inside a Cell of Microsoft Excel Maaka MS Office Support 2 27-01-2012 07:59 PM
insert picture in excel 2007 based on cell reference joe.polkendare Windows Software 5 25-07-2011 11:40 PM
How to insert last date in excel 2010 Calum Windows Software 5 18-02-2010 12:07 AM


All times are GMT +5.5. The time now is 07:35 PM.