Results 1 to 9 of 9

Input Box repeatedly pops up

Threaded View

  1. #1
    Registered User
    Join Date
    09-26-2014
    Location
    Seattle, WA
    MS-Off Ver
    2010
    Posts
    5

    Question Input Box repeatedly pops up

    Hi All, I think I'm close to getting this code right - but the input box repeatedly pops up, and I need further code to stop the repetition after a user enters a value.

    Basically - I am looking for an input box to pop up if a user inputs any value greater than 0 in cell A1, the input box then asks "Please enter the number of days you will be visiting this week" and inputs the value into A2. Thanks in advance for the help, I'm love learning this stuff and am pretty new.

    Private Sub Worksheet_Change(ByVal Target As Range)
       If Worksheets("Sheet1").Range("A1").Value > 0 Then _
         Wkly = InputBox("Please enter the number of days you will be visiting this week")
         Cells(2, "A").Value = Wkly
    End Sub
    Last edited by jmrwd3; 10-01-2014 at 05:30 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Easy Question i think
    By JJJJJJJJJJ in forum Excel General
    Replies: 2
    Last Post: 09-08-2008, 06:43 PM
  2. Easy Question
    By ScottyNM in forum Excel General
    Replies: 6
    Last Post: 12-22-2006, 02:58 AM
  3. [SOLVED] An easy question... Maybe?
    By Lydon Bergin in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-25-2006, 01:15 PM
  4. new user with easy question? not easy for me
    By speakeztruth in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 06-03-2005, 05:05 PM
  5. easy question .... i think
    By Dean in forum Excel General
    Replies: 1
    Last Post: 01-06-2005, 03:06 PM

Tags for this Thread

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