Results 1 to 19 of 19

Thread: VBA code to replace "1" with "7:00/ 15:30"

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #5
    VBAX Regular
    Joined
    Mar 2023
    Posts
    13
    Location
    As i said, i am newbie. Barely know a thing or two about VBA.
    I attached the spreadsheet in which i need this replacement to take place.
    Basically, when i type 1 and press enter, i need it to automatically change into "7:00/ 15:30".
    Many thanks !

    Quote Originally Posted by georgiboy View Post
    Welcome to the forum,

    What version of Excel do you use?

    Also a little confused, in the title you state: "VBA Code to replace"
    But then in the main text you state: "But with no macros."
    Microsoft® Excel® for Microsoft 365 MSO (Version 2302 Build 16.0.16130.20332) 64-bit
    Attached Files Attached Files

Posting Permissions

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