Apr 4, 2012 #1 gmailJoe MIS Joined Apr 4, 2012 Messages 2 Location US Newbie question here. Is it possible to prompt a user for input via a message box and pass that input to a cell with vbscript? Thanks
Newbie question here. Is it possible to prompt a user for input via a message box and pass that input to a cell with vbscript? Thanks
Apr 5, 2012 #2 ClulessChris IS-IT--Management Joined Jan 27, 2003 Messages 890 Location GB sounds like you're looking for an inputbox Never knock on Death's door: ring the bell and run away! Death really hates that! Upvote 0 Downvote
sounds like you're looking for an inputbox Never knock on Death's door: ring the bell and run away! Death really hates that!
Apr 5, 2012 Thread starter #3 gmailJoe MIS Joined Apr 4, 2012 Messages 2 Location US I found something like this for an inputbox. <script type="text/vbscript"> Function myFunction() fname=InputBox("Enter your name") End Function </script> How can I make the text entered into the inputbox populate a certain cell? Can I use more that one inputbox per script? Upvote 0 Downvote
I found something like this for an inputbox. <script type="text/vbscript"> Function myFunction() fname=InputBox("Enter your name") End Function </script> How can I make the text entered into the inputbox populate a certain cell? Can I use more that one inputbox per script?
Apr 5, 2012 #4 ChrisHirst IS-IT--Management Joined Nov 23, 2001 Messages 8,049 Location GB So this is more of a forum707 question than it is a forum329 question Chris. Indifference will be the downfall of mankind, but who cares? Time flies like an arrow, however, fruit flies like a banana. Webmaster Forum Upvote 0 Downvote
So this is more of a forum707 question than it is a forum329 question Chris. Indifference will be the downfall of mankind, but who cares? Time flies like an arrow, however, fruit flies like a banana. Webmaster Forum
Apr 5, 2012 #5 jges Technical User Joined Oct 24, 2003 Messages 537 Location US gmailJoe said: How can I make the text entered into the inputbox populate a certain cell? Click to expand... Are we talking about a cell in an HTML table, a cell in a spreadsheet, or something else? gmailJoe said: Can I use more that one inputbox per script? Click to expand... Yes, but if you are scripting an HTML page and need several inputs, you may want to use input forms. Upvote 0 Downvote
gmailJoe said: How can I make the text entered into the inputbox populate a certain cell? Click to expand... Are we talking about a cell in an HTML table, a cell in a spreadsheet, or something else? gmailJoe said: Can I use more that one inputbox per script? Click to expand... Yes, but if you are scripting an HTML page and need several inputs, you may want to use input forms.