More info on how you want to get the variable? Input box ?

--
Don Guillett
SalesAid Software

"Greg B" wrote in message
...
I use the code below to import information to a userform, As you can see
it
is static. What changes can be made to make volitile?


TextBox6.Text = Worksheets("INVOICE").Range("A17").Value

Thanks

Greg