+ Reply to Thread
Results 1 to 6 of 6

Application.Inputbox not showing up on the screen. Dialog box is getting skipped.

  1. #1
    Forum Contributor
    Join Date
    12-01-2007
    Location
    USA-North Carolina
    MS-Off Ver
    MS Office 2016
    Posts
    2,712

    Application.Inputbox not showing up on the screen. Dialog box is getting skipped.

    Hi,

    I am enclosing the file/code.

    My issue is that in my vba code i prompt user for info using the application.inputbox method and for some reason the inputbox is just getting skipped. I put a msgbox prior and after the application.inputbox statement.......both msgbox statements get displayed but not the application.inputbox.............very strange.

    Can someone look at it and tell me why the application.inputbox is getting skipped?
    Attached Files Attached Files
    Last edited by welchs101; 09-25-2012 at 12:55 PM.

  2. #2
    Forum Contributor
    Join Date
    12-01-2007
    Location
    USA-North Carolina
    MS-Off Ver
    MS Office 2016
    Posts
    2,712

    Re: Application.Inputbox not showing up on the screen. Dialog box is getting skipped.

    Another question for the admin for this site?

    I just created this post and when i clicked on submitt it "kinda" had an error........so i created a 2nd post exactly the same as the first. System told me i had already created this post. When i went to myprofile to see the latest post .....i could not find the post the system just told me was a duplicate. I still cant find it when i go to myprofile.

    Any ideas whats going on?

  3. #3
    Forum Expert nilem's Avatar
    Join Date
    10-22-2011
    Location
    Ufa, Russia
    MS-Off Ver
    2013
    Posts
    3,377

    Re: Application.Inputbox not showing up on the screen. Dialog box is getting skipped.

    try to reduce the length of the query string. For example, this works for me
    Please Login or Register  to view this content.

  4. #4
    Forum Contributor
    Join Date
    12-01-2007
    Location
    USA-North Carolina
    MS-Off Ver
    MS Office 2016
    Posts
    2,712

    Re: Application.Inputbox not showing up on the screen. Dialog box is getting skipped.

    huh, i thought i tried that.

    Thanks!

    Do you or anyone else know the "max" query string length? Also, does anyone know what happens if you go past this max value?

  5. #5
    Forum Expert nilem's Avatar
    Join Date
    10-22-2011
    Location
    Ufa, Russia
    MS-Off Ver
    2013
    Posts
    3,377

    Re: Application.Inputbox not showing up on the screen. Dialog box is getting skipped.

    Quote Originally Posted by welchs101 View Post
    Do you or anyone else know the "max" query string length?
    255 characters
    and an error "Type mismatch" occurs if you enter more than 255 characters.
    Last edited by nilem; 09-25-2012 at 09:36 AM.

  6. #6
    Forum Contributor
    Join Date
    12-01-2007
    Location
    USA-North Carolina
    MS-Off Ver
    MS Office 2016
    Posts
    2,712

    Re: Application.Inputbox not showing up on the screen. Dialog box is getting skipped.

    thanks Nilem.

    I guess i had error messages turned off and this is why i did not see that. Good to know about the 255 characters.

    Thanks.

+ 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