How to create Serial Number using given digits for my userform

badzxie14

New Member
Joined
Nov 1, 2021
Messages
1
Office Version
  1. 2021
  2. 2019
  3. 2016
  4. 2013
  5. 2011
  6. 2010
Platform
  1. Windows
Good day I am not an IT expert but I am currently having a project of database on work. I am having trouble for the codes for my ADD COMMAND BUTTON of getting a serial number for 2 columns for the first column will retain the number and the second column will copy the digits of the first column then copy the above row with increasing (+)

For example in my ADD button if I click it I want it to function as follows

...to appear in worksheet .... ....in userform two text box first box will retain the 6-21- second box will show the next increment of given number which is 085287

A B C
Control No. Serial No. A (6-21-) Serial No. B (085287) > Add button clicked
1 6-21- 6-21-085288 >Add button clicked
2 6-21- 6-21-085289 >Add button clicked
3 6-21- 6-21-085290 >Add button clicked
4 6-21- 6-21-085291 >Add button clicked
 

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.

fadee2

Active Member
Joined
Nov 7, 2020
Messages
398
Office Version
  1. 2021
Platform
  1. Windows
hy badzxie14,
Welcome to the board. I would suggest providing a sample file that would that would make it easier for everyone trying to help, to better understand and suggest solutions accordingly, rather then interpreting the query and making assumptions.
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,151,820
Messages
5,766,634
Members
425,364
Latest member
jstubs99

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
Top