Excel VB User forms

Hi All

I'm very new to using VB.

I'm using Excel to provide client reports based on information input into spreadsheet.

I have automated the print out of the many different reports using macros and limited vb commands.

What I'm trying to do is create a user form to act as a validation sheet which the user will check that the output data is correct before printing the many reports.

I have been ok with creating message boxes with the data pulled from the cells within the spreadsheet but want to format it and present it better.

I have been advised to use a userform which the user clicks to confirm the the data is correct.

I have been able to create a basic user form and believe that you use a textbox. Where I'm stuck is how to pull the data from a cell in the spread sheet e.g. Sheet 1 cell C5 into the textbox on the user
the user form.

Many thanks

Jon

Hi Many thanks for your prompt reply.

Still struggling.

Ive created a user form and inserted a textbox1.

How/where do I copy the code you have provided which will allow the data from sheet 1 C5 to show in the textbox1 within the userform. I also don't want the user to be able to change the text in the field.

I have tried viewing the code relating to the texbox and changing it to your code - but no success.

This has done it!

Once I've got the form populated with a few more fields. I will be looking at a yes/no radio button a the end of the form to confirm that the data has been checked that will allow printing.

Thanks again.

Jon