How to write a VBA with User form for Entering the DATA to print a cheque

Dear Sir,

I need a solution for Printing a cheque ( Size : Width 20.50 Length 85 ) and to save the data for future.

First I will enter the data which is required to me to print out in Cheque But I want to use drop down button for selecting the Payee Name. So I Need one Sheet whare I maintain my payee data and other data I will enter manually.

And Then there should be button to say Print then It should show me the Print Preview with data I entered and desired cheque.

If it is satisfactory I will say print.

Then It should print the same On the cheque which is in my printer.
Sheet 1 I want to enter data with payee name in drop down.
Sheet 2 Records where it should take data from sheet one and keeps as record one by one.
Sheet 2 Data should visible but should not allowed to edit but.
sheet 3 Cheque printout
Sheet 4 : Payee Data.

This file should get you started.

No way to start

When you open the file you must enable macros, also known as enable content

I have put a button on each sheet to start the process

there are three text boxes at the top of the user form.

If you enter part of the payee name in each box then the macro will find the name for you

For example if your name is John Martin Smith

then entering Joh ma and sm in the three boxes will select the name.

then enter the other data.

Can you please do it from side : I have enabled micro, When Im entering the data All other Tabs in USer forms are disabling