+ Reply to Thread
Results 1 to 6 of 6

Application.Inputbox getting Method of Data Member not found

  1. #1
    Valued Forum Contributor
    Join Date
    12-02-2009
    Location
    Austin, Tx
    MS-Off Ver
    Excel 2016 Office 365 64-Bit
    Posts
    3,449

    Application.Inputbox getting Method of Data Member not found

    Upgraded my office version a few months ago, and for the first time today used an application.inputbox macro that I hadn't used in a while. Got a "Method or Data Member Not Found" error. Couldn't figure out why it failed, so copied a couple of different sample macros from other sites, had the same issue. "InputBox" works find, but "Application.Inputbox" fails, and I can't understand why. Below is a sample macro that fails for me. Any help would be appreciated.
    Please Login or Register  to view this content.
    I know I'm not stupid, but I suspect I'm a lot stupider than I think I am

  2. #2
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    2016 primarily
    Posts
    6,084

    Re: Application.Inputbox getting Method of Data Member not found

    That is Excel code, not Word. Word doesn't have an Application.Inputbox method.
    Rory
    I drink, and I know things

  3. #3
    Valued Forum Contributor
    Join Date
    12-02-2009
    Location
    Austin, Tx
    MS-Off Ver
    Excel 2016 Office 365 64-Bit
    Posts
    3,449

    Re: Application.Inputbox getting Method of Data Member not found

    Ah, that's good to know! I didn't realize there would be a difference on that, but it certainly explains why my code is failing.

  4. #4
    Forum Guru macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,578

    Re: Application.Inputbox getting Method of Data Member not found

    You don't need to use Application.Inputbox in Excel or Word. Inputbox on its own works fine in both and Application.Inputbox causes an error in Word.
    Cheers,
    Paul Edstein
    [Fmr MS MVP - Word]

  5. #5
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    2016 primarily
    Posts
    6,084

    Re: Application.Inputbox getting Method of Data Member not found

    You do in this case in Excel as itís returning a range object (type:=8)

  6. #6
    Valued Forum Contributor
    Join Date
    12-02-2009
    Location
    Austin, Tx
    MS-Off Ver
    Excel 2016 Office 365 64-Bit
    Posts
    3,449

    Re: Application.Inputbox getting Method of Data Member not found

    I agree with Rorya, that was the whole reason for using Application.Inbox, but I think I can reconfigure my macro to use just the vanilla inputbox version. If not I'll make a form.

    Thanks for all your help.

+ 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. Compile Error : Method or data member not found
    By ManateeProfanity in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-24-2019, 10:38 PM
  2. Method or Data Member Not Found
    By adbrad in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-12-2016, 09:05 AM
  3. Method or data member not found
    By Rob K in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 07-27-2015, 03:50 PM
  4. [SOLVED] Error: Method or Data Member Not Found
    By k64 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-21-2015, 08:39 AM
  5. Method or data member not found
    By katieshields in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-02-2014, 08:49 AM
  6. [SOLVED] error: Method or Data Member not found
    By CRIMEDOG in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-26-2013, 11:01 AM
  7. Method or Data Member not Found
    By Syed Haider Ali in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-22-2005, 09:27 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