Print and store autogenerated number for a form

basicjohn

New Member
Joined
Aug 9, 2005
Messages
14
Hi there,

Need help, I have created sort of a form with Excel. Need to print this out as a blank form with a autogenerated number and store it on the output in a specified field, and it needs to avoid duplicated numbers. If cannot be done in Excel can this be done in Access?

Hoping to hear from you all.
 

Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"
Here is some basic code that could be attached to a button on the sheet :-
Code:
Sub test()
    '- increase number in cell A1
    ActiveSheet.Range("A1").Value = ActiveSheet.Range("A1").Value + 1
    '- print sheet
    ActiveSheet.PrintOut
    '- save workbook with new number
    ActiveWorkbook.Save
End Sub
 
Upvote 0

Forum statistics

Threads
1,211,772
Messages
6,103,879
Members
447,883
Latest member
Hgiang0101

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top