+ Reply to Thread
Results 1 to 4 of 4

Prompt Box not appearing

  1. #1
    Registered User
    Join Date
    08-07-2012
    Location
    Cambridge, Ontario
    MS-Off Ver
    Excel 2010
    Posts
    6

    Prompt Box not appearing

    Hi,

    I've been working with this code for a while and it's been working great.

    I have programming in a few prompt boxes. Two for simple yes, no answers and the next two for user input.

    As of right now - don't know why - the input prompts aren't even appearing. The yes, no prompt boxes work fine. And the code automatically jumps right do the default input of both input prompts as if the user had just pressed enter both times....can someone please help to figure out why this is happening?

    Please Login or Register  to view this content.
    The prompt is automatically executing the 8.3 portion of the elseif statement....

    Thanks for any help.

  2. #2
    Forum Contributor
    Join Date
    05-25-2012
    Location
    California
    MS-Off Ver
    Excel 2010
    Posts
    194

    Re: Prompt Box not appearing

    What I see looks fine here - I would imagine the issue lies somewhere else in your code. Got a sample workbook to post?

  3. #3
    Forum Expert
    Join Date
    01-12-2007
    Location
    New Jersey
    Posts
    2,127

    Re: Prompt Box not appearing

    This code also looks fine to me. In a previous post, you mentioned per my suggestion that you are using the SendKeys "{ENTER}" somewhere in your code. Is that line perhaps interfereing with this line?

  4. #4
    Registered User
    Join Date
    08-07-2012
    Location
    Cambridge, Ontario
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: Prompt Box not appearing

    Ya the code works fine....but it's completely neglecting to show the prompt window...I really can't figure out why...unfortunately I can't give a workbook to work with because of company privacy reasons, sorry.

    I don't have the SendKeys command in this code. That was for something different.

    The problem seemed to occur when I changed iInput2 to a double and added in an 8.3 option.
    This is what the code looked like before, both prompts work perfectly fine:

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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