Setting value

  • Thread starter Thread starter John
  • Start date Start date
J

John

I have a user prompted input that I need to compare in two
statments on the same query, is it possible to assign the
user prompted value to a variable then check the variable
against two differerent functions
 
John

Try
myVariable = InputBox("Question to user", "Title of Inputbox"

This will assign the value of the inputbox to the variable 'myVariable'. You can then compare this as required

The InputBox function returns a string so you may need to do some conversions depending on what type of value you want (and the usual data validation)

Hope this helps
Tra


----- John wrote: ----

I have a user prompted input that I need to compare in two
statments on the same query, is it possible to assign the
user prompted value to a variable then check the variable
against two differerent function
 
Back
Top