MsgBox "You picked " & ChooseOne("red" & vbTab & "green" & vbTab & "blue")
Function ChooseOne(strTabDelimitedChoices)
'Returns one of several string choices.
'Returns empty string if there is a problem.
Dim fs, web, doc
Dim strFile, strChoice
Dim intChars
Dim dtTime
On Error Resume Next
Set web = CreateObject("InternetExplorer.Application")
If web Is Nothing Then
ChooseOne = ""
Exit Function
End If
'Increase displayed width to accomodate longest string choice
intChars = 0
For Each strChoice In Split(strTabDelimitedChoices, vbTab)
If Len(strChoice) > intChars Then intChars = Len(strChoice)
Next
If intChars > 20 Then
web.Width = 250 + 6 * (intChars - 20)
Else
web.Width = 250
End If
web.Height = 200
web.Offline = True
web.AddressBar = False
web.MenuBar = False
web.StatusBar = False
web.Silent = True
web.ToolBar = False
web.Navigate "about:blank"
'Wait for the browser to navigate to nowhere
dtTime = Now
Do While web.Busy
'Don't wait more than 5 seconds
Wscript.Sleep 100
If (dtTime + 5/24/60/60) < Now Then
ChooseOne = ""
web.Quit
Exit Function
End If
Loop
'Wait for a good reference to the browser document
Set doc = Nothing
dtTime = Now
Do Until Not doc Is Nothing
Wscript.Sleep 100
Set doc = web.Document
'Don't wait more than 5 seconds
If (dtTime + 5/24/60/60) < Now Then
ChooseOne = ""
web.Quit
Exit Function
End If
Loop
'Write the HTML form
doc.Write "Choose"
doc.Write "Choose One:
"
'Show the form
web.Visible = True
'Wait for the user to choose, but fail gracefully if a popup killer.
Err.Clear
Do Until doc.Forms(0).elements("submit").Value <> "OK"
Wscript.Sleep 100
If doc Is Nothing Then
ChooseOne = ""
web.Quit
Exit Function
End If
If Err.Number <> 0 Then
ChooseOne = ""
web.Quit
Exit Function
End If
Loop
'Retrieve the chosen value
ChooseOne = doc.Forms(0).elements("choice").Value
web.Quit
End Function