Hi,
I need some assistance with some excel VBA code I'm having issues with.
I have an excel workbook which has a user login when opened and then controls what sheets are visble.
The issue I have is the code I'm currently using only allows numeric for a password.
I would like the code changed to allow for passwords with letters and numeric
Attached a document with the full code and below is the part which checks the password. Currently when i have a password with letters in it just says worng password.
'Check the login and passcode for the administrator
If user <> "" And Not IsNumeric(user) And Code <> "" And IsNumeric(Code) Then
For Each AName In [login to view URL]("S8:S35")
'If AName = Code Then ' Use this for passcode text
If AName = CLng(Code) And [login to view URL](0, -1) = user Then ' Use this for passcode numbers only
This is urgent so if anyone can help please get in touch.
Thanks,
John
I already see what is needed to make it working with letters too
Relevant Skills and Experience
I have 20 years experience with MS Excel/Access/VBA: databases, finance, statistics, accounting, CRM etc.
Proposed Milestones
£15 GBP - ready working code
Additional Services Offered
£0.01 GBP - Client gets whole access and rights for the code I made. Warranty covers any bugs detected later.
£15 GBP en 1 día
4,9 (8 comentarios)
4,4
4,4
9 freelancers están ofertando un promedio de £15 GBP por este trabajo
Hello John,
I am Luis from Venezuela and it will be my pleasure to assist you in this project.
Relevant Skills and Experience
Excel and visual basic
Proposed Milestones
£12 GBP - job done
Please contact me by chat
I have done similar projects & confident to assist you. I'll take responsible to complete the work accurately & on time.
Relevant Skills and Experience
I have done similar projects & confident to assist you. I'll take responsible to complete the work accurately & on time.
Proposed Milestones
£20 GBP - payment once completed