Set ws =Worksheets("INVOICE")

' do your stuff

ws.Range("A17").Value

'doen't matter what the name is then

--
HTH

Bob Phillips

"Greg B" wrote in message
...
What I have done is, I have wrote a sales database and when I have
finished
it copies the worksheet and renames it. I want the ability to view the
invoice later when needed. I was going to select the sheet and then have
this code for every textbox on the userform grab the information from the
various worksheets.

I know the code originally is for the invoice worksheet only I more wanted
it to be for the active worksheet but I just cant make it happen.

Thanks

Greg
"Don Guillett" wrote in message
...
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