Results 1 to 2 of 2

Need help with inputbox function

Threaded View

AnirudhC Need help with inputbox... 04-21-2017, 04:19 PM
mike7952 Re: Need help with inputbox... 04-21-2017, 04:47 PM
  1. #1
    Registered User
    Join Date
    03-02-2017
    Location
    India
    MS-Off Ver
    2016
    Posts
    24

    Need help with inputbox function

    Hi, so my data has kids who are being billed "Weekly", "Monthly", and "Bi-monthly". It is dynamic data keeps on changing.

    The problem is that On alternate weeks the data that needs to be pulled keeps on changing accordingly to their billing status.
    If I put "Y" in the inputbox it takes a yes for the second string as well i.e it pulls the monthly kids as well.

    here is the code so far: -

    Dim answer As String
        
        answer = InputBox("Do you want to take the Bi-monthly kids? Y/N")
        
            If answer = "N" Then
            'take only the weekly kids
             End If
    
            If answer = "Y" Then
            'take both the weekly and the bi-monthly kids
                End If
                
        Range("A" & Rows.Count).End(xlUp).Offset(1).Select
                    
    Dim answer2 As String
        answer2 = InputBox("Do you want to the monthly kids aswell? Y/N")
               
               If answer = "Y" Then
               'take the weekly, bi-monthly and monthly kids as well
               
               If answer = "N" Then
               Exit Sub
    
               End If
    Last edited by AnirudhC; 04-21-2017 at 06:34 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] MACRO: If user clicks cancel in inputbox,then do nothing. Problem with inputbox appearance
    By Tona in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-05-2015, 04:33 AM
  2. [SOLVED] Insert function to 'Cancel' Button in InputBox
    By leleco in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-16-2014, 11:52 AM
  3. [SOLVED] Inputbox with search function
    By SMasher in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-08-2013, 05:41 AM
  4. [SOLVED] InputBox Function not as flexible as needed
    By dystopianprotagonist in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 03-04-2013, 10:59 PM
  5. [SOLVED] I need to use InputBox function
    By john456852 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 08-22-2012, 04:34 PM
  6. inputbox function in vba
    By grk_chakri in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-26-2012, 01:24 AM
  7. Inputbox button control + msgbox for empty inputbox
    By D_Rennie in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-30-2009, 12:39 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