Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Prompt for input

Discussion in 'Information Technology' started by Simon Harris, Jul 28, 2006.

Tags:
  1. Simon Harris

    Simon Harris
    Expand Collapse
    Guest

    Hi All,

    Is there a VBA equivilant to javascript prompt? I want to pop up a box (From
    a module) asking the user for a date. I know this will return a string, but
    I plan to specifiy the input and then validate it.

    All I can find is MsgBox, which seems to be the same as a JavaScript alert.

    Any help will be much appreciated.

    Regards,
    Simon.

    --
    -
    * Please reply to group for the benefit of all
    * Found the answer to your own question? Post it!
    * Get a useful reply to one of your posts?...post an answer to another one
    * Search first, post later : http://www.google.co.uk/groups
    * Want my email address? Ask me in a post...Cos2MuchSpamMakesUFat!
     
  2. Loading...


  3. SusanV

    SusanV
    Expand Collapse
    Guest

    The function you're looking for is InputBox

    --
    hth,
    SusanV

    "Simon Harris" <too-much-spam@makes-you-fat.com> wrote in message
    news:%231BbuiEnGHA.4684@TK2MSFTNGP02.phx.gbl...
    > Hi All,
    >
    > Is there a VBA equivilant to javascript prompt? I want to pop up a box
    > (From a module) asking the user for a date. I know this will return a
    > string, but I plan to specifiy the input and then validate it.
    >
    > All I can find is MsgBox, which seems to be the same as a JavaScript
    > alert.
    >
    > Any help will be much appreciated.
    >
    > Regards,
    > Simon.
    >
    > --
    > -
    > * Please reply to group for the benefit of all
    > * Found the answer to your own question? Post it!
    > * Get a useful reply to one of your posts?...post an answer to another one
    > * Search first, post later : http://www.google.co.uk/groups
    > * Want my email address? Ask me in a post...Cos2MuchSpamMakesUFat!
    >
     
  4. Simon Harris

    Simon Harris
    Expand Collapse
    Guest

    Great, thanks Susan.

    "SusanV" <svanallen@nospam-mvps.org> wrote in message
    news:eI7ZmxEnGHA.4604@TK2MSFTNGP02.phx.gbl...
    > The function you're looking for is InputBox
    >
    > --
    > hth,
    > SusanV
    >
    > "Simon Harris" <too-much-spam@makes-you-fat.com> wrote in message
    > news:%231BbuiEnGHA.4684@TK2MSFTNGP02.phx.gbl...
    >> Hi All,
    >>
    >> Is there a VBA equivilant to javascript prompt? I want to pop up a box
    >> (From a module) asking the user for a date. I know this will return a
    >> string, but I plan to specifiy the input and then validate it.
    >>
    >> All I can find is MsgBox, which seems to be the same as a JavaScript
    >> alert.
    >>
    >> Any help will be much appreciated.
    >>
    >> Regards,
    >> Simon.
    >>
    >> --
    >> -
    >> * Please reply to group for the benefit of all
    >> * Found the answer to your own question? Post it!
    >> * Get a useful reply to one of your posts?...post an answer to another
    >> one
    >> * Search first, post later : http://www.google.co.uk/groups
    >> * Want my email address? Ask me in a post...Cos2MuchSpamMakesUFat!
    >>

    >
    >
     

Share This Page