+ Reply to Thread
Results 1 to 4 of 4

Numeric Input Popup Box

  1. #1
    Registered User
    Join Date
    07-01-2013
    Location
    Western Springs, IL
    MS-Off Ver
    Excel 2016
    Posts
    18

    Numeric Input Popup Box

    Hello,
    I need to add a popup input box function to my vba macro which will allow the user to enter a number which will be inserted into Cell J1 and then another popup input box for the user to enter a number which will insert into Cell K1. If the input by the user is Not numeric then I need an error to occur so that the user may enter a valid number. After the second entry there should be no more popup input boxes appearing.
    Thank you in advance for any help you are able to give.
    A
    Last edited by ajam; 07-01-2013 at 06:53 PM.

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Numeric Input Popup Box

    Hi and welcome to the forum.

    Perhaps

    Please Login or Register  to view this content.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Valued Forum Contributor tehneXus's Avatar
    Join Date
    04-12-2013
    Location
    Hamburg, Germany
    MS-Off Ver
    Work: MS-Office 2010 32bit @ Win8 32bit / Home: MS-Office 2016 32bit @ Win10 64bit
    Posts
    944

    Re: Numeric Input Popup Box

    Hi,

    or:
    Please Login or Register  to view this content.
    Please use [CODE]-TAGS
    When your problem is solved mark the thread SOLVED
    If an answer has helped you please click to give reputation
    Read the FORUM RULES

  4. #4
    Registered User
    Join Date
    07-01-2013
    Location
    Western Springs, IL
    MS-Off Ver
    Excel 2016
    Posts
    18

    Re: Numeric Input Popup Box

    This worked great for my purposes. Thank you.

+ 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