input box
 

Can I put an input box that has a variable in it?

for example the input box would say:

"Type the amount between date1 and date2"

input box
 

this idea
Sub inputboxvar()
x = InputBox("type date bigger than " & Range("a2") & " less than"etc)
MsgBox x
End Sub

--
Don Guillett
SalesAid Software

"srroduin" wrote in message
...
Can I put an input box that has a variable in it?

for example the input box would say:

"Type the amount between date1 and date2"

input box
 

Thanks....works great!

"Don Guillett" wrote:

this idea
Sub inputboxvar()
x = InputBox("type date bigger than " & Range("a2") & " less than"etc)
MsgBox x
End Sub

--
Don Guillett
SalesAid Software

"srroduin" wrote in message
...
Can I put an input box that has a variable in it?

for example the input box would say:

"Type the amount between date1 and date2"

input box
 

glad to help

--
Don Guillett
SalesAid Software

"srroduin" wrote in message
...
Thanks....works great!

"Don Guillett" wrote:

this idea
Sub inputboxvar()
x = InputBox("type date bigger than " & Range("a2") & " less than"etc)
MsgBox x
End Sub

--
Don Guillett
SalesAid Software

"srroduin" wrote in message
...
Can I put an input box that has a variable in it?

for example the input box would say:

"Type the amount between date1 and date2"