User Form creation support in EXCEL

You seem to be asking for much more than just support with creating a user form here. This is a big project - have you considered using the commercial services section, where you would be able to offer some financial incentive?

Well,
what you are really asking is an entire application to be built for you.
There are many sites that can help and have sample files but the question is how much vba knowledge do you yourself have to create a basic vba code for this.
Once somebody writes this you will have to maintain it an be able to modify it yourself unless you decide to hire someone to write and maintain it for you.
There are many sites that have many tips and ides, I'll list some for you.
http://www.cpearson.com/Excel/Topic.aspx
https://sites.google.com/site/beyondexcel/home
https://www.teachexcel.com/excel-tutorial/
http://www.rondebruin.nl/search.htm here you type userform as search criteria

I'll read the word file and see if I can put you on the right track, the userform you created you have hardcoded many things but this is not the best way, if you do you will always have to edit the code if items get added or removed.

I'll let you know what I can do to help you on the way.

I agree for 200% with AliGW

Hi There,

Sorry if i have asked more than what i supposed to expect
I can create or modify a code however not sure on 2 points, and hence asked support,
1. I have a column in which centre name will be updated(Bangalore, Delhi, Sri Lanka, USA, Australia.etc.) and in another column the device ID, when the password match how to get the ID only for the selected centre in section 2 as said earlier
2. Giving the access rights to specific peoples

Also help me in updating error report if “Device actual status” Updated as “In Transit”, then “Currently used centre” and “Device Location” column should not be same
second error.png

Hi Praveen, I understood your question but looking at you file I can only tell you that it is not just a do this, do that issue, but I will try to explain some of it:
You have several named ranges which you use to fill the corresponding listboxes and comboboxes.

Section 1
You should have a short list of Unique Location names, I checked and extracted that list form the user table you have

You should only populate Location with this small list of UNIQUE names
Then after a location is clicked / selected you must trigger a routine to only list the user names of those working at that location. That user enters his or her password and after that you need a macro to lookup that person's name and check if the password complies and then return a true if the password is correct and then the user rights can be stored in a variable.

All other actions must be tested with an If Expert Admin or whatever to see if that item may be shown or accessed.

All these actions you should write in UDF (User defined Functions)

I do not know how far your VBA knowledge goes but this is something that will require quite some more than basic knowledge and of course somebody who understands the whole process.
You Word attachments explains the section and so but then, a lot of programming is required.

I would personally set the different sections in Frames and only have these become visible once the user is authenticated and then only to those items that come with the allocated access rights.

I hope that I have able to explain myself a little to you.

It is a pity that you do not react to what has been written, but, anyway.
This is it for starters.
You may build from here.
All this does is show you the userform, you select a location, the Name and enter the password. If the combination is correct then Frame1 (Section2) and Frame3 (Section 3) will become enabled and the list will be filled.
That is all I have done for now.
To close the form press the Close button to clear the press the Unload.

This already took 2-3 hours so if you want somebody to build an application for you , you must employ somebosy with enough VBA knoeledge or contact somebody to do it for oyu.

I hope this gives you some idea.