+ Reply to Thread
Results 1 to 5 of 5

Randomly selecting number from a list of numbers

  1. #1
    Registered User
    Join Date
    06-24-2011
    Location
    Texas
    MS-Off Ver
    Excel 2007
    Posts
    36

    Exclamation Randomly selecting number from a list of numbers

    I am trying to set up a "daily tip" msg box for using a complicated spreadsheet I have designed. I have about 65 tips typed up, and each one is assigned a number. (1-65) Is I wast to ask the user if they would like to see the daily tip, and if yes then have excel randomly select one of the numbers (1-65) and show that numbers corrosponding tip.
    Any ideas?

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,576

    Re: Randomly selecting number from a list of numbers

    Try =VLOOKUP(RANDBETWEEN(1,65), range, 2, FALSE)

  3. #3
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,576

    Re: Randomly selecting number from a list of numbers

    This will work only if user open workbook once per day For a message box youll need macro

  4. #4
    Registered User
    Join Date
    06-24-2011
    Location
    Texas
    MS-Off Ver
    Excel 2007
    Posts
    36

    Re: Randomly selecting number from a list of numbers

    thats perfect, I only want to ask the user if they want to see a tiip right when the enter the workbook. So I cant show a msgbox on workbook open?

  5. #5
    Registered User
    Join Date
    06-24-2011
    Location
    Texas
    MS-Off Ver
    Excel 2007
    Posts
    36

    Re: Randomly selecting number from a list of numbers

    I am ok with using a macro, thats what all my messages are typed into

+ 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