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 ?

--
Don Guillett
SalesAid Software
donaldb@281.com
"Greg B" <laptopgb@ihug.com.au> wrote in message
news:d6fkmq$plk$1@lust.ihug.co.nz...
> 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
>
>

[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
"Don Guillett" <donaldb@281.com> wrote in message
news:%23TsDdn7WFHA.2520@TK2MSFTNGP09.phx.gbl...
> More info on how you want to get the variable? Input box ?
>
> --
> Don Guillett
> SalesAid Software
> donaldb@281.com
> "Greg B" <laptopgb@ihug.com.au> wrote in message
> news:d6fkmq$plk$1@lust.ihug.co.nz...
> > 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
> >
> >
>
>

[Bob Phillips]

Set ws =Worksheets("INVOICE")

' do your stuff

ws.Range("A17").Value

'doen't matter what the name is then

--
HTH

Bob Phillips

"Greg B" <laptopgb@ihug.com.au> wrote in message
news:d6fm5q$sep$1@lust.ihug.co.nz...
> 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" <donaldb@281.com> wrote in message
> news:%23TsDdn7WFHA.2520@TK2MSFTNGP09.phx.gbl...
> > More info on how you want to get the variable? Input box ?
> >
> > --
> > Don Guillett
> > SalesAid Software
> > donaldb@281.com
> > "Greg B" <laptopgb@ihug.com.au> wrote in message
> > news:d6fkmq$plk$1@lust.ihug.co.nz...
> > > 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
> > >
> > >
> >
> >
>
>