input msgbox

[detlion1643]

i have some code as follows

dim strcat as string
dim strbrand as string

strbrand = ***
strcat = ***

i am trying to find a way to popup a box that a user can input a string for strbrand and hit enter, then another popup box that a user can input a string for strcat and hit enter.

my whole sub uses these inputs for everything, and right now, i change the input in the code itself for testing and it's getting tedious lol.

 

[Domski]

Dim strcat As String
Dim strbrand As String
strbrand = InputBox("Enter first value")
strcat = InputBox("Enter second value")

Dom

 

[bertie]

You are looking for an InputBox.

strbrand = InputBox("Please enter....")

 

[detlion1643]

thanks everyone. i tried msgbox with inputs lol, but inputbox works better.