Error when populating active cell with date from calendar in user form

**jwala** · 12-06-2010, 12:19 AM

Dear Members
I am using multipage user form, installed calendar to populate the active cell with date.

The following is the scenario:

a) When active cell is selected, calendar will pop up and when date selected, it populate the active cell with date

Following Error is coming:

A) Runtime error ‘13’ type mismatch

I AM UPLOADING THE FILE FOR REFERENCE

Regards
jwala

Error showing in the following part of Code:

Please Login or Register  to view this content.

**royUK** · 12-06-2010, 02:26 AM

I'm not sure where you write to a cell with that code. It adds a date to a control, this works

Please Login or Register  to view this content.

**jwala** · 12-06-2010, 03:02 AM

Dear Royuk

The code which you given, works perfectly

Thank you for your valuable time

I have one more question,

In my user form " I AM USING COMBO BOX, FOR FILLING TIME"

Error is :

a. Time is showing in "DECIMAL FORMAT ( 9:00 showing as "0.375") in the text box of user form

b. I am using "ROW SOURCE" only from another worksheet, for combo box

Regards
jwala

Error when populating active cell with date from calendar in user form

LinkBack

Thread Tools

Rate This Thread

Display

Error when populating active cell with date from calendar in user form

Re: Error when populating active cell with date from calendar in user form

Re: Error when populating active cell with date from calendar in user form

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions