User Form Formula

[sbruner]

I have created the template for a user form at the beginning of a macro. It
simply asks the user to enter a product code and click Ok.
I am not a professional programmer and am unsure how to take the information
that the user inputs and store it as a variable to be repeatedly called up in
my macro at various points. Can anyone help?

[Jim Thomlinson]

Your question is kind of vague so here is a very generic bit of code for you
to loo at...

Public Sub GetDataFromUser()
Dim strUserInput As String

strUserInput = InputBox("Please enter your name.", "Name")

MsgBox "Your name is " & strUserInput

Call GetAddress(strUserInput)
End Sub

Private Sub GetAddress(ByVal UserName As String)
Dim strAddress As String

strAddress = InputBox("Hi, " & UserName & ". What is your address",
"Address")

MsgBox UserName & " lives at " & strAddress

End Sub

It gets the user to inut their name. That name is output and then passed to
another procedure to be used some more.
--
HTH...

Jim Thomlinson


"sbruner" wrote:

> I have created the template for a user form at the beginning of a macro. It
> simply asks the user to enter a product code and click Ok.
> I am not a professional programmer and am unsure how to take the information
> that the user inputs and store it as a variable to be repeatedly called up in
> my macro at various points. Can anyone help?

[Bob Phillips]

ans = Inputbox("Please supply a product code")

--
HTH

Bob Phillips

"sbruner" <[email protected]> wrote in message
news:[email protected]...
> I have created the template for a user form at the beginning of a macro.
It
> simply asks the user to enter a product code and click Ok.
> I am not a professional programmer and am unsure how to take the
information
> that the user inputs and store it as a variable to be repeatedly called up
in
> my macro at various points. Can anyone help?

[jjk]

You should look up some tutorials.

Reading the codes from these projects is a good start.
<single line>
http://support.microsoft.com/search/...rform+tutorial
</single line>