Hi Raj, Your workbook has a couple of references to files I don't have on my system - (1) LsAgXLB.xla (although I don't think this add-in relates to your question and (2) Microsoft Calendar Control 2007.
The calendar form (UserForm2) comes up blank on my system, presumably because I am missing the control, so I am unable to help with that at this time. That might be a good control to use, but an alternative is DTPicker, which is part of Windows Common Controls 2 (http://support.microsoft.com/kb/297381) and may already be installed on your system(s). DTPicker seems to automatically highlight the current date. It also looks like a combobox control, but when clicked on provides a calendar. It hasn't been updated in many years, though. Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Raj Mahapatra Sent: Saturday, March 24, 2012 10:29 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ date should be today's date in calendar in user form of excel please find the attached file and click "RUN ENTRY" Then Click 'Transcation Date" Thanks & Regards On Sat, Mar 24, 2012 at 12:30 PM, Asa Rossoff <a...@lovetour.info> wrote: Hi Raj, Can you attach a sample file? From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Raj Mahapatra Sent: Friday, March 23, 2012 9:34 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ date should be today's date in calendar in user form of excel hi group, i want date in calendar in user form should be today's date automatically. Thanks & Regards -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ---------------------------------------------------------------------------- -------------------------- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ---------------------------------------------------------------------------- -------------------------- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ---------------------------------------------------------------------------- -------------------------- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com
