+ Reply to Thread
Results 1 to 3 of 3

Reading a input value from a message box

  1. #1
    Forum Contributor
    Join Date
    10-12-2018
    Location
    Leesburg, FL
    MS-Off Ver
    2013
    Posts
    113

    Reading a input value from a message box

    Is there a way to use MessageBox or some other built-in function to allow the user to enter a value? My macro needs a date value before it can run and it was originally getting this from the file name, but this is no longer the case. I really don't want to have to create a form so I was hoping there was a work around.

  2. #2
    Forum Expert Roel Jongman's Avatar
    Join Date
    03-28-2015
    Location
    Netherlands
    MS-Off Ver
    Office 365
    Posts
    1,483

    Re: Reading a input value from a message box

    inputbox is simular as msgbox but as the name indicates can do more then show messages

    https://docs.microsoft.com/en-us/off...ation.inputbox

  3. #3
    Forum Contributor
    Join Date
    10-12-2018
    Location
    Leesburg, FL
    MS-Off Ver
    2013
    Posts
    113

    Re: Reading a input value from a message box

    Quote Originally Posted by Roel Jongman View Post
    inputbox is simular as msgbox but as the name indicates can do more then show messages

    https://docs.microsoft.com/en-us/off...ation.inputbox
    Thanks Roel

+ 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. Replies: 8
    Last Post: 04-20-2017, 02:24 AM
  2. Reading User Input in Excel Outmail Application
    By sgb1223 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-22-2014, 05:03 PM
  3. Adding an input message to each cell to bring back corrsponding message
    By Nic31 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-01-2014, 09:28 AM
  4. message input box returns lines/rows based on the input
    By excelandclark in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 06-03-2013, 07:35 PM
  5. need of pop up message dynamically using data validation input message method
    By vba_life in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-09-2010, 09:03 AM
  6. Replies: 3
    Last Post: 08-10-2009, 12:38 PM
  7. Lookup command reading user input cell
    By ldavison10 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-07-2008, 09:04 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