+ Reply to Thread
Results 1 to 3 of 3

Generating Numbers - Automatically

  1. 05-30-2023, 01:54 PM #1
    Danilo Flaiban
    Danilo Flaiban is offline
    Registered User
    Join Date
    03-29-2022
    Location
    Sao Paulo, Brazil
    MS-Off Ver
    Excel 365
    Posts
    80

    Generating Numbers - Automatically

    Hi , everybody...
    I would like that every time the workbook is opened , a MsgBox appeared with a yes or no option .
    If YES , auto generating number on cell "G5" .
    Ex : Cell "G5" = 503/23 (number and Year)

    Clicked YES , automatically G5 = 504/23

    When Year 2024 , G5 = 504/24

    Debit Note.jpg
    Reply With QuoteRegister To Reply
  2. 05-30-2023, 02:01 PM #2
    bsalv
    bsalv is offline
    Forum Expert
    Join Date
    01-25-2011
    Location
    Belgium, Alveringem
    MS-Off Ver
    Excel 2003, 2007, 365
    Posts
    1,457

    Re: Generating Numbers - Automatically

    in Thisworkbook
    Please Login or Register  to view this content.
    Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
    Reply With QuoteRegister To Reply
  3. 05-30-2023, 02:31 PM #3
    Danilo Flaiban
    Danilo Flaiban is offline
    Registered User
    Join Date
    03-29-2022
    Location
    Sao Paulo, Brazil
    MS-Off Ver
    Excel 365
    Posts
    80

    Re: Generating Numbers - Automatically

    Good Idea !!! Perfect

    Only change for this :

    Please Login or Register  to view this content.
    Thanks...

    Moderator Comment. I have added code tags per the forum rules. Please abide by all forum rules you agreed to when you joined.
    Last edited by alansidman; 05-30-2023 at 10:08 PM.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Excel for automatically generating PO numbers and using a macro to populate template
    By Rd026 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 11-19-2019, 07:11 AM
  2. [SOLVED] Pls help with randomly generating numbers from a specific grid of numbers
    By ds2020 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-19-2015, 09:16 AM
  3. [SOLVED] Automatically Generating Invoice Numbers
    By berman53 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-09-2015, 02:05 PM
  4. Generating random numbers or set of numbers which add up to a certain number?
    By sakkthi in forum Excel General
    Replies: 14
    Last Post: 10-24-2013, 08:03 AM
  5. Generating graphs automatically
    By IrfanB in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-30-2007, 04:51 PM
  6. create self-generating numbers with letters and numbers
    By cxlough41 in forum Excel General
    Replies: 11
    Last Post: 01-03-2006, 09:20 PM
  7. Generating Calender Automatically
    By Mei in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 05-29-2005, 11:42 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1