Results 1 to 5 of 5

Scroll down through ActiveX for dates but turns into values - how to change to date

Threaded View

  1. #1
    Registered User
    Join Date
    04-25-2013
    Location
    Montreal, Quebec
    MS-Off Ver
    Excel 2010
    Posts
    76

    Scroll down through ActiveX for dates but turns into values - how to change to date

    I am creating a schedule spreadsheet and I just recently discovered the ActiveX scroll down key...I LOVE IT! I've used it for another speadsheet for data and it works like a charm!

    I followed the same directions to do it on this new spreadsheet using it for dates....but my dates change to values when it goes in the assigned cell! It is formatted for dates prior but, somehow it is overwritten and overts itself to a value.

    I've attached an example.
    example.JPG
    Please be kind in your explanation...I'm really good at Excel but VBA is a new language for me...lol

    Thank you.
    Last edited by Leith Ross; 01-27-2014 at 10:22 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 5
    Last Post: 01-16-2014, 11:51 AM
  2. turns numbers into dates
    By Jonathan9 in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 08-01-2013, 07:49 AM
  3. Using ActiveX CheckBox Control to make a cell change colour and clear values
    By drmit in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-20-2012, 04:18 AM
  4. Scroll bar (Form Control) - Resetting the scroll bar to particular values
    By Vishb in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-29-2011, 04:10 AM
  5. activeX scroll bars
    By joop.broekman@guar.danisco.com.nospam in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-22-2006, 06:10 AM

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