VBA code for sequential numbers for a column containing letters and numbers

**YuriyBaron** · 06-26-2018, 09:13 PM

I have a column with letters and numbers. ex: REJ0001, REJ0002, REJ0003...REJ10935. The next line needs to be REJ10936. I would like to have VBA code to look at the range in (Table1) column (REJECT NO.) and determine the highest value and then add one to it. This should be done when USERFORM1 is opened.

I can then insert the new number into a new row with all other fields in USERFORM1.

**alansidman** · 06-26-2018, 09:47 PM

In this example the Reject No. Field is in Column G. Change yours to what ever it is in your spreadsheet. You can put this in a Open form Event. Since I don't have your file and form, I was unable to test on your file.

Please Login or Register  to view this content.

**YuriyBaron** · 06-26-2018, 10:03 PM

Thank you!

VBA code for sequential numbers for a column containing letters and numbers

LinkBack

Thread Tools

Rate This Thread

Display

VBA code for sequential numbers for a column containing letters and numbers

Re: VBA code for sequential numbers for a column containing letters and numbers

Re: VBA code for sequential numbers for a column containing letters and numbers

Thread Information

Users Browsing this Thread

Similar Threads

Generate sequential letters and numbers populated on textbox (userform)

[SOLVED] code for copying sequential numbers

Sort Alphabetically letters and numbers(column) - sorted letters on the top in the column

[SOLVED] Making a Part# List, Sequential Increments with Letters and numbers in front...

[SOLVED] Find missing entries from a list of sequential numbers and letters in a column?

[SOLVED] Separating a column by numbers vs. letters when numbers are at the end of the cells?

Sequential column numbers

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions