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
I have built a user form I would like users to enter their details into.
This includes'
Date
Employee ID
Name
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