Displaying a number on a VB form

[Pauljj]

Hello All,

I am setting up a form for users to fill in, on it, I was the sales persons sales figures to show on the form.

The figure is already being calculated on a sheet called 'Promotions' in cell ref U83....is there a way I can get that figure to appear on the form ?


Thanks
Paul

 

[Nine Zero]

If you add a label to the form then you can call it by doing this

Label1.Caption = Sheets("Promotions").Range("U83").Value

 

[Pauljj]

Thanks Nine Zero!

Much appreciated