Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Excel Sheet information in Userform Creation

0

I want to get the excel one sheet information in userform which will be best can any one suggest me for creating the userform for easy access and editing the information in it and saving it.

Please find the attachment of my File.

My file has (first letter is capital and rest is small.)

Username: Admin

Password: Admin

excelmacros-vba
MS Office Version: Optional
posted by: ajazuddin (rep: 4) on Thu Dec 22, 2022 at 3:58 pm
Answer
Discuss

Discussion

Hi

What do you mean by "one sheet information" pleaae? 
John_Ru (rep: 6142) Dec 23, '22 at 1:46 am
Hi John_Ru
Greetings!
I mean to say in the excel-VBA file there is one sheet name "information Data" I want that in userform the same details where I can see the multiple information of employees and also I need to edit it for any updates or changes from there itself. If it can be done, please suggest and provide me with the solution.

Please access my file and, if possible, suggest me with your best suggestion.
ajazuddin (rep: 4) Dec 23, '22 at 3:49 am
Add to Discussion

Answers

0

Hi Ajazuddin

I don't have time to give you a full solution but suggest you look in the "UserForms in Excel" section of the Tutorials page. I think this specific tutorial from Don will be a good start: Multi-Column ComboBox Drop Down Menus in Forms.

Hope this helps. Please come back if you have problems.

posted by: John_Ru (rep: 6142) on Fri Dec 23, 2022 at 6:20 am
Discuss

Discussion

Thank you John_Ru
I wil check and will create that userform with combo box
ajazuddin (rep: 4) Dec 23, '22 at 7:02 am
No problem. If that works for you, kindly mark this Answer as Selected 
John_Ru (rep: 6142) Dec 23, '22 at 7:12 am
Did that tutorial work for you? 
John_Ru (rep: 6142) Dec 29, '22 at 5:26 am
Any joy with that? 
John_Ru (rep: 6142) Jan 1, '23 at 3:48 pm
Add to Discussion


Answer the Question

You must create an account to use the forum. Create an Account or Login