How can this code be changed

[Greg B]

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

 

[Don Guillett]

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

 

[Greg B]

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

 

[Bob Phillips]

Set ws =Worksheets("INVOICE")

' do your stuff

ws.Range("A17").Value

'doen't matter what the name is then