+ Reply to Thread
Results 1 to 12 of 12

code works on exel2003 doesn't work 2010

  1. #1
    Forum Contributor
    Join Date
    06-02-2019
    Location
    libya
    MS-Off Ver
    2010
    Posts
    734

    code works on exel2003 doesn't work 2010

    hello
    i need help i have this file contains calendar when i double click on c2, d2 ,it supposes showing calendar and copy in c3,d3 this file only works on version 2003 i would run also version 2010
    Attached Files Attached Files
    Last edited by ABDELFATTA; 04-30-2020 at 02:28 PM.

  2. #2
    Valued Forum Contributor
    Join Date
    11-15-2010
    Location
    Dallas, TX
    MS-Off Ver
    Excel 2003
    Posts
    538

    Re: code works on exel2003 doesn't work 2010

    What you presented does not work in 2003 either. You have no controls on the form, yet you attempt to set .Value for control Calendar1.

    That's a very strange sheet for "left-to-right" language users. Column A is on the far right edge. I've never seen that before.

  3. #3
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MO Prof Plus 2016
    Posts
    6,908

    Re: code works on exel2003 doesn't work 2010

    @ Oppressed1

    In order to satisfy certain language writing habits from right to left Excel can switch direction of the worksheet.

    I've seen it done here only a couple of times so far.
    Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
    You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.

  4. #4
    Forum Contributor
    Join Date
    06-02-2019
    Location
    libya
    MS-Off Ver
    2010
    Posts
    734

    Re: code works on exel2003 doesn't work 2010

    sorry about this i edited my post and i no know what exactly tool to insert from add tools , i try with another tool like with monthview but the code not works it supposes when i double click on c2, d2 , then showing calendar and when i choose day from calendar ,it supposes copying date in c3,d3

  5. #5
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MO Prof Plus 2016
    Posts
    6,908

    Re: code works on exel2003 doesn't work 2010

    Works fine for me.
    Attached Files Attached Files

  6. #6
    Forum Contributor
    Join Date
    06-02-2019
    Location
    libya
    MS-Off Ver
    2010
    Posts
    734

    Re: code works on exel2003 doesn't work 2010

    it give me this what means so
    Attached Images Attached Images
    Last edited by ABDELFATTA; 04-30-2020 at 10:12 PM.

  7. #7
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MO Prof Plus 2016
    Posts
    6,908

    Re: code works on exel2003 doesn't work 2010

    Invalid attachment.

  8. #8
    Forum Contributor
    Join Date
    06-02-2019
    Location
    libya
    MS-Off Ver
    2010
    Posts
    734

    Re: code works on exel2003 doesn't work 2010

    i edited post#6

  9. #9
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MO Prof Plus 2016
    Posts
    6,908

    Re: code works on exel2003 doesn't work 2010

    Download and register mscal.ocx.

    Or download a standalone calendar control, there are plenty on the internet.

  10. #10
    Valued Forum Contributor
    Join Date
    11-15-2010
    Location
    Dallas, TX
    MS-Off Ver
    Excel 2003
    Posts
    538

    Re: code works on exel2003 doesn't work 2010

    Bakerman, just for FYI, your "works fine" attachment works for me too - YOURS does. Perhaps the earlier attachment was changed on edit, because I could have sworn it had an empty form.

    Also FYI, I didn't have to download Tequila-sounding-named mscal.ocx :P for I see it in
    C:\Program Files (x86)\Microsoft Office\OFFICE11

    These are just to confirm/agree with you by the way.
    Hey, a Belgian, from the land of PressTube!

  11. #11
    Forum Contributor
    Join Date
    06-02-2019
    Location
    libya
    MS-Off Ver
    2010
    Posts
    734

    Re: code works on exel2003 doesn't work 2010

    thanks bakerman i Downloaded and register mscal.ocx. it works very well

  12. #12
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MO Prof Plus 2016
    Posts
    6,908

    Re: code works on exel2003 doesn't work 2010

    You're welcome and thanks for rep+.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. VBA doesn't work on CSV file, but works on XLS?
    By songhaegyo in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-28-2017, 09:36 AM
  2. VBA Code works by step by step, doesn't work by running
    By lucasar in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-24-2016, 06:33 AM
  3. [SOLVED] FileOpen works then doesn't work - Why?
    By delaing in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-09-2016, 06:54 PM
  4. Excel to Word macro doesn't work on Word 2013 if sheet is hidden (works fine on 2010)
    By dreddster in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-29-2015, 04:37 AM
  5. Get code that works on excel version 2007 to work on version 2010
    By Agent1 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-21-2014, 01:23 AM
  6. Cancel printing VBA code doesn't works on excel 2010
    By saesaria in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-28-2013, 06:08 AM
  7. it works, it doesn work, its works....and so on.
    By Naz in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-30-2005, 09:05 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