Can I use Enter Parameter Value dialog?

[WaiveIt]

Hello all.

Can I open a "Enter Parameter Value" dialog box to capture and use the input without running a query?

something like

 ParaBox ("Enter the Hostname", vbEntParameterVal, "Hostname Required")

or

    Set pDialog = Application.ParaValueDialog(mso?????)

I need a short string input from the users at application load, and I'd like to use the "Enter Parameter Value" dialog.

I'm about to build a workaround that will invoke a SQL statement to save the entry to a temp table, but it'd be nice if I could just call up that dialog box and store the entry as a VBA variable.

Thanks

 

[jdraw]

Or Inputbox

It would help readers if you told us What you were doing that involved users entering a test.

Thanks nanscombe.

 

[nanscombe]

I think you may have meant Inputbox.

(note to self .. must type quicker. )

 

[WaiveIt]

Awesome! Exactly what I was looking for!
I just quickly tested the following and the MsgBox displayed my Input.

Sub testInputBox()
Dim strInput As String
        strInput = InputBox("Enter the Hostname", "Hostname Required")
        
        MsgBox strInput
End Sub

I aim to use this to capture a hostname which users will obtain through a packaged batch file that shares the folder holding the BackEnd on a LAN and displays the hostname during installation of the BackEnd.

When FrontEnds are subsequently installed users will simply enter a hostname and allow the vba to complete the connection string to the BackEnd. It's tucked away in a corner and hidden; so I don't want to ask the users to find it before they can connect to the BackEnd.