How can this code be changed

G

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
 
G

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
 
B

Bob Phillips

Set ws =Worksheets("INVOICE")

' do your stuff

ws.Range("A17").Value

'doen't matter what the name is then
 
Top