Userform - Where to start

Let me start by I'm not asking anyone to make this form for me, I would rather do it myself so I can learn. I've messed around with userforms in the past but it was a good few years ago, and I ultimately didn't create anything, so I'm after some guidance on where to start and how to proceed.

I've tried to find some tutorials on youtube, etc but the majority of them seem to be about formatting and design, rather than the back-end and setup.

I've been passed a fairly large and overly complex spreadsheet regarding employees and their training records, I'm looking to make the whole thing much easier to use and update, and figured a userform would simplify it a lot for the users. A database would probably be best, but my access knowledge is even worse than my userform knowledge.

Information I need to be visible to the user;

• Employee Name
• Employed (Y/N) - Need to still be able to search historical data for those who are no longer employed by the company
• Department
• Job Title
• Certificate Name
• Completion Date
• Expiry Date

Information that needs to be editable by users;

• Employee Information - Update and Add New
• Ability to Hide Employees - no longer works for the company but records are still kept
• Certificate Information - including how many months before certification needs to be renewed
• Ability to Hide Certifications - should it be superseded with another certification, records still kept
• Update completion date, when certification has been renewed

I'm sure if someone can get me started I can figure a lot of it out myself, I'm usually quite good at picking things up once I get going. I'm just struggling to understand how to best layout my data in Excel, and making it accessible and editable by the userform.

Thanks.

Microsoft database would be better, since it does a lot for you ...like self make user forms.
otherwise in excel you MUST ADD EVERY BOX & LABEL YOURSELF and then program it, where access can make it in a single click.

Start now to learn database now and skip the bulky clumsy way excel does it.
you wont regret it.

I understand that a database would suit this project better. However last time I tried to learn Access a lot of it went over my head, and I was struggling for a long time (before I ultimately changed jobs and didn't need to learn it anymore). Whereas I'm already very familiar with Excel, and have a good understanding of VBA - I just really need to know the starting point and I could do this fairly quickly I feel. I spent at least a month trying to learn Access last time, and got pretty much nowhere with the tutorials I was using, and feel I could have this working in Excel, pretty much as needed, inside a week if I knew the basics to getting it running.

Originally Posted by AliGW

Did you read anything else in my post, or just the last line?

Yes I did read the rest of your post. I was responding to the post before yours when you responded, so I hadn't read it at that point.

But you also stated that you aren't familiar with user forms themselves and part of my query having the user form reference the existing data, so I don't have to re-enter it all.

So thank you for your advice about the data but that isn't all I'm after here.

I won't go into too much here but it's best to think of userforms no differently than you do a worksheet.

For example to programmatically set the value of "A1" on the worksheet "My Sheet" using the value of "C6" from "Their Sheet";

Please Login or Register  to view this content.

Using a userform, setting "A1" value with the value found in TextBox1, we'd achieve a similar result as such;

Please Login or Register  to view this content.

("Me" is used by the userform to identify itself, the same can be achieved using the name of the userform, normally "userform1". Also ".Text" can be used in place of ".Value" with a textbox, to specify that the value is exclusively text)

If you apply the same logic you would creating any other macro, you should be fine.

Thanks for all the advice everyone. I'll mark this thread as solved, and use it as a jumping off point. If I get stuck further down the line I'll make a new post about the specifics.