+ Reply to Thread
Results 1 to 3 of 3

date field not updating concatenated results

  1. #1
    Registered User
    Join Date
    07-28-2008
    Location
    Bedford, UK
    Posts
    2

    date field not updating concatenated results

    Hi guys, very new here so please accept my ignorance, but here goes.

    I am writing a spreadsheet with 2 lines of concatenated alpha numeric digits, the first line being non editable, and the secnd having various options to either select (drop down selector) or type into the fields (date for example), however I have found that whenever I enter a date into the from and to date fields these do not update the concatenated line (basically this is to give a user an insert sql script to add entries in an oracle database) and I am struggling to understand how I can make this field auto update.

    The only thing I had thought of was creating a date selector, however i would need th date selector to be invisible until clicked and disappear again when a date is selected?

    Anyone have any ideas?

    Cheers
    Ray

  2. #2
    Forum Expert oldchippy's Avatar
    Join Date
    02-14-2005
    Location
    Worcester, UK
    MS-Off Ver
    Excel 2007 (Home)
    Posts
    7,097
    Hi Ray,

    Welcome to the forum, may be this might help?

    http://www.fontstuff.com/vba/vbatut07.htm
    oldchippy
    -------------


    Blessed are those who can give without remembering and take without forgetting

    If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.

    Click here >>> Top Excel links for beginners to Experts

    Forum Rules >>>Please don't forget to read these

  3. #3
    Registered User
    Join Date
    07-28-2008
    Location
    Bedford, UK
    Posts
    2
    Cheers boss, i'll have a peep at that and see if it sorts it out.

    Ray

+ Reply to Thread

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