+ Reply to Thread
Results 1 to 4 of 4

Selecting a sheet based on Input from a MsgBox

  1. #1
    Registered User
    Join Date
    02-27-2019
    Location
    Hagerstown, MD
    MS-Off Ver
    2010
    Posts
    2

    Question Selecting a sheet based on Input from a MsgBox

    OK- first post. Also first time writing a macro.
    So I am trying to build a macro to ask a user to enter a date, and based on the date entered it will go to a shared drive and pull certain data from different files/sheets. Problem is there is a file that has different numbered tabs for the days of the month, and it is not able to select that day's tab.

    Ive found that I am getting an "Subscript out of range error" because even though I activate this second workbook (with the tabs as days) it is trying to open the numbered tab on the workbook I want to pull the data in to. I have worked on this for about a week with no success so now I am asking for smarter people for help.

    Here is my code:
    ------------------------------------
    Please Login or Register  to view this content.
    Last edited by nsorresso; 02-27-2019 at 05:38 PM.

  2. #2
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2016
    Posts
    6,826

    Re: Selecting a sheet based on Input from a MsgBox

    Please use code tags around posted vba code!!!
    ---
    Hans
    "IT" Always crosses your path!
    May the (vba) code be with you... if it isn't; start debugging!
    If you like my answer, Click the * below to say thank-you

  3. #3
    Registered User
    Join Date
    02-27-2019
    Location
    Hagerstown, MD
    MS-Off Ver
    2010
    Posts
    2

    Re: Selecting a sheet based on Input from a MsgBox

    I apologize, this is my first time posting. I am not sure I know what you mean.

  4. #4
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2016
    Posts
    6,826

    Re: Selecting a sheet based on Input from a MsgBox

    Like this:

    Please Login or Register  to view this content.
    Read the rules

+ 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. [SOLVED] Selecting data in an array based on input variables
    By dvess11 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-31-2019, 12:28 PM
  2. Selecting Cells based on Row value and short new sheet based on Cell value
    By John1969 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-11-2016, 03:51 AM
  3. Compare & update unique data between 2 files based on selcted year (through input msgbox)
    By Manish_Gupta in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-17-2014, 01:35 AM
  4. Selecting Higher/Lower Value based on User Input
    By FTN in forum Excel Formulas & Functions
    Replies: 21
    Last Post: 06-14-2011, 10:31 AM
  5. Selecting Worksheet based on User Input.
    By CJPHX in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-25-2010, 01:58 PM
  6. Selecting Data Based on User Input
    By famousp in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-23-2009, 04:16 PM
  7. How to do Input Msgbox to copy select column to sheet 2 ?
    By yannipr in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-10-2008, 03:52 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