+ Reply to Thread
Results 1 to 8 of 8

Macro - Drop Down Free Text / Time-Date Function

  1. #1
    Registered User
    Join Date
    11-20-2008
    Location
    Freeport
    Posts
    4

    Macro - Drop Down Free Text / Time-Date Function

    I have two problems. I am trying to create a Triage Note Sheet for a Doctor's office. It would be great to be able to have the Date and Time populate the sheet upon opening it, but it is important that the date and time be fixed on that sheet from there on out. Also, I'd like to give as many drop-down options as possible for users but I want to also give them the option to free text in those same drop down cells.

    First, I would like to use the NOW function in a cell (C6), then lock that value when another cell (C7) has a text string entered in it. C6 would remain locked even after the worksheet was saved and edited repeatedly.

    Second, I would like to use the validation feature and create a list that has multiple values to select from. I would also like to be able to free text in that cell if needed.

    Any help would be appreciated.
    Last edited by VBA Noob; 11-21-2008 at 12:43 PM.

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678
    Welcome to the forum.

    Please take a few minutes to read the Forum Rules about thread titles, and then edit yours to make it descriptive of your problem.
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Forum Contributor
    Join Date
    02-27-2008
    Posts
    764

    macro

    Hi
    In the attached book, if you enter a text in C6, the time will be displayed in C7. method to validate data from a list is described. for multiple selection a list /combo box may be used (I had done this long time back and can't remember details)
    Ravi
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    11-20-2008
    Location
    Freeport
    Posts
    4

    VBA Help

    Thanks for your help. They both work great! This is just what I am looking for. Is there any way that you know where I could use the save feature in file menu (or save gui) that would always save to the text string of a cell to a particular location on a network drive? In the triage note, we enter the Patient's name in a cell and if we could save the sheet using the naming in that cell, and that sheet would always save to the same location, that would save a couple clicks.

    Thanks!

  5. #5
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988
    Title amended for you. Please follow the rules below next time

    Many thanks

    VBA Noob
    _________________________________________


    Credo Elvem ipsum etian vivere
    _________________________________________
    A message for cross posters

    Please remember to wrap code.

    Forum Rules

    Please add to your signature if you found this link helpful. Excel links !!!

  6. #6
    Forum Contributor
    Join Date
    02-27-2008
    Posts
    764

    macro

    Hi
    here is a macro which saves the current sheet (sheet2 in this case) as new workbook in the name/string contained in E1 and path as specified inthe code
    Please Login or Register  to view this content.
    Ravi

  7. #7
    Registered User
    Join Date
    11-20-2008
    Location
    Freeport
    Posts
    4
    sorry, see post below
    Last edited by K9VonRichtoffen; 11-25-2008 at 04:49 PM.

  8. #8
    Registered User
    Join Date
    11-20-2008
    Location
    Freeport
    Posts
    4
    I am having a bit of trouble getting the macro to save by cell contents to work. We run Novell, could this be part of the problem. I tried to have it save to my c drive, but it wouldn't work and it didn't cause error. Here is what I did...

    Please Login or Register  to view this content.

    I was originally hoping to save to network location H:\MMCPA\Gastro\Triage"
    I also changed the Sheets to Sheets("Sheet1"), no change.

    Any ideas?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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