Hi

I'm using an Excel sheet named Customers. In cell S302 I have a running
total of all customers purchases . I have inserted a Text Box on the user
form - how do I code the VBA to show the value of cell S302 in the Text Box
on the User Form

Any help would be much appreciated

Cheers ----- Mully

Textbox1.Text = Worksheets("Sheet1").Range("S302").Text

--

HTH

RP
(remove nothere from the email address if mailing direct)


"mully" wrote in message
...
Hi

I'm using an Excel sheet named Customers. In cell S302 I have a running
total of all customers purchases . I have inserted a Text Box on the user
form - how do I code the VBA to show the value of cell S302 in the Text
Box
on the User Form

Any help would be much appreciated

Cheers ----- Mully

Hi Bob

Thinking I'm getting there - however got to leave things for now - Big
Football Match here in the UK today.
Thanks for all your help

Cheers Mully

"Bob Phillips" wrote:


Textbox1.Text = Worksheets("Sheet1").Range("S302").Text

--

HTH

RP
(remove nothere from the email address if mailing direct)


"mully" wrote in message
...
Hi

I'm using an Excel sheet named Customers. In cell S302 I have a running
total of all customers purchases . I have inserted a Text Box on the user
form - how do I code the VBA to show the value of cell S302 in the Text
Box
on the User Form

Any help would be much appreciated

Cheers ----- Mully

I know. I am there. Come on the Gooners!


"mully" wrote in message
...
Hi Bob

Thinking I'm getting there - however got to leave things for now - Big
Football Match here in the UK today.
Thanks for all your help

Cheers Mully

"Bob Phillips" wrote:


Textbox1.Text = Worksheets("Sheet1").Range("S302").Text

--

HTH

RP
(remove nothere from the email address if mailing direct)


"mully" wrote in message
...
Hi

I'm using an Excel sheet named Customers. In cell S302 I have a
running
total of all customers purchases . I have inserted a Text Box on the
user
form - how do I code the VBA to show the value of cell S302 in the
Text
Box
on the User Form

Any help would be much appreciated

Cheers ----- Mully

Hi Bob

Thanks for the help !!! the bloody lucky Gooners spoilt my day

Cheers --- Mully

"Bob Phillips" wrote:

I know. I am there. Come on the Gooners!


"mully" wrote in message
...
Hi Bob

Thinking I'm getting there - however got to leave things for now - Big
Football Match here in the UK today.
Thanks for all your help

Cheers Mully

"Bob Phillips" wrote:


Textbox1.Text = Worksheets("Sheet1").Range("S302").Text

--

HTH

RP
(remove nothere from the email address if mailing direct)


"mully" wrote in message
...
Hi

I'm using an Excel sheet named Customers. In cell S302 I have a
running
total of all customers purchases . I have inserted a Text Box on the
user
form - how do I code the VBA to show the value of cell S302 in the
Text
Box
on the User Form

Any help would be much appreciated

Cheers ----- Mully

Never mind Mully,

It may seem lucky, but at the end of it, the winners are those that stick it
in the net most times! And of course, the ref wasn't inclined to add extra
time until MU scored :-)

PS you don't name yourself after the great Alan Mullery by any chance?


"mully" wrote in message
...
Hi Bob

Thanks for the help !!! the bloody lucky Gooners spoilt my day

Cheers --- Mully

"Bob Phillips" wrote: