Solved: Variables in message box

[JZB]

Hi Guys

I am producing a macro which will chart the performance of any individual the user chooses.

How do i create a pop up box at the start of the macro where the user can specify the name of the individual they wish to see a chart of?

Also how can i then make that answer my variable?

The rest of the macro is quite simple. Just using find the variable and then chart the range of offset cells.

Just stuck on this bit .

Thanks

Jon

[Bob Phillips]

[vba]

myVar = InputBox("name of individual?")
[/vba]

[GTO]

Greetings,

If the names are in a range of rows or columns, you may wish to consider a userform with a listbox. This prevents mis-typing issues.

If not, maybe InputBox:
[vba]
Option Explicit

Sub exa()
Dim strName As String

strName = Application.InputBox(Prompt:="Type in the name of the person to ceck", _
Title:=vbNullString, _
Type:=2)
If Not strName = vbNullString _
And Not strName = "False" Then
MsgBox "Other code to return " & strName
End If

End Sub
[/vba]

Does that help?

Mark

[JZB]

just about to apply - will let you know

appreciate the help guys

[JZB]

perfect. works a treat

thanks a lot