Library Spread Sheet, with add new book macros

I run a small library in a prison using Microsoft Excel and I have my data in a table (sortable drop down menu columns and auto colored rows). I want to add a "Add New Book" button to the form that brings up an input box waiting for the me to input the Author, Title, Genre {TEXT}, Price {Currency}, & Type {COMBOBOX} (hardback, softback, paperback). After getting the input I want the macro to generate a unique ID for the book with the prefix based upon the Type selected from the combo box. I need the program to loop through the entire A column of my table and find the lowest available number for that specific selection (hardback, softback, paperback) and the assign that prefix with that number as the book's ID.

ID example

hardback
HH-0105

softback
HS-0054

paperback
HP-1045

I want each number to four digits long plus the TYPE- prefix. Below is the form I have created so far but VBA is beyond my ability to code very well. I find it many magnitudes more difficult that C++ or PHP. Thanks for your help.


Module1

Please Login or Register  to view this content.

Forms.UserForm1

Please Login or Register  to view this content.

I would have attached an example file but the attache button on this form just brings up a thin horizontal line with no file browser.

(How to) Upload a Workbook directly to the Forum
(please do not post pictures or links to worksheets)

• Click Advanced next to Quick Post button at the bottom right of the editor box.
• Scroll down until you see "Manage Attachments",
• Click the "Choose" button at the upper left (upload from your computer).
• Select your file, click "open", click "upload"
• Once the upload is completed the file name will appear below the input boxes in this window.
• Close the Attachment Manager window.
• Click "Submit Reply"

Note: Please do not attach password protected workbooks/worksheets
Ensure to disable any Workbook Open/Autorun macros before attaching!

Your ID number format is inconsistent, e.g.,
0917006291.1
RC1.TD1.1

What should happen with such?