RANDBETWEEN

[bbworld]

Hello,

I have built a user form I would like users to enter their details into.

This includes'

Date
Employee ID
Name
Email

I have a field called ID Gen where I am using for RANDBETWEEN formula to generate a 'unique' alphanumeric number. I say 'unique' as I have read that sometimes using the fomula, duplicates can happen.

Formula

=CHAR(RANDBETWEEN(65,90))&CHAR(RANDBETWEEN(65,90))&RANDBETWEEN(10,999999)

This produces a alphanumeric value such as "UI533792"

When in excel running it as a formula this works just fine. When I am trying to get this to work in the user form it fails to run. (exhaustive Google for VBA has not yielded any results either )

Finally, I am looking for some assistance with copying all the data from the screenshot via a transpose paste into a hidden worksheet. For the employee ID and email address, I would like to have these validated in the user form via the hidden worksheet and an error returned if a user with the employee ID or email address exist.

If this is all good then create the ID Gen and copy this over to the hidden worksheet and clear the content on the user form ready for the next input.

Cheers
Dan

 

[GraH]

To make something unique you can also use a simple increment (with/without date/Timestamp combo) and store the last generated ID in a field. Can't help with the rest.

 

[bbworld]

@Fluff

I’m looking to understand more about generating a hex identifier with 8 characters that is unique and would enter into a field in a form recently debugged - thanks again @Fluff.

Sub Show Form () Error

Hello, I am a newbie with VBA and have reviewed the previous articles on the Sub Show Form () error I am getting in the attached. I have followed a learning video and rechecked my content twice yet the same error is presenting. The workbook is attached and the code in particular that is...

www.mrexcel.com

This is the final working form that just needs the identifier.

Look forward to learning more about variables.