Results 1 to 8 of 8

Forms and controls

Threaded View

fatalcore Forms and controls 04-29-2012, 03:09 PM
Charles Re: Forms and controls 04-29-2012, 03:27 PM
fatalcore Re: Forms and controls 04-29-2012, 09:43 PM
Charles Re: Forms and controls 04-30-2012, 01:24 PM
fatalcore Re: Forms and controls 05-01-2012, 04:00 AM
Charles Re: Forms and controls 05-01-2012, 02:53 PM
fatalcore Re: Forms and controls 05-01-2012, 10:42 PM
Charles Re: Forms and controls 05-02-2012, 11:49 AM
  1. #1
    Forum Contributor
    Join Date
    02-07-2011
    Location
    Bhutan
    MS-Off Ver
    Excel 2007
    Posts
    244

    Forms and controls

    Hi,
    I am very new to the forms concept.
    I have been working with calendar and worksheet.
    I have been using this Now() function to update the current date in the calender
    But if I want to restrict selecting previous date, then how should I do that?
    Now I placed a button in the form which will override the restriction on the calender when a password is matched.
    I also want to display the current date and time in the text box as I load the form.But I can't do that, when even i click on anything the form gets updated but not by default.How do I show current date and time on form load time?

    Last, If I select to enable the calendar with the password, is it possible to copy the date and time in the sheet1 instantly?And if I reopen the form and enable password to enter previous date, it will again append the date and time below the previous entry?
    Please guide me.
    Thanks in advance.
    Me.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1