VBA USERFORM coding for Excel

[KatOpti]

Title updated to comply with forum rules.

Help my VBA skills have become rusty through lack of use and I have a tight deadline to meet. I have created a UserForm for a dataset (MASTER LIST) and I’m struggling to remember how to code it up to make it work.

As you can see from the attached sample file I have managed to design the form and get the Add/Close buttons to work (yeah me).
First of all I want to be able to browse the data in the form however I cannot remember how to get the form to find and display the dataset. I also cannot remember what code I need for the Next and Previous buttons.

The form currently creates a URN for new records but I realise this might be a problem if I want it to open up as a “browser”. I may need another button to create a New record or have the Next/Previous buttons perform the update when focus moves to another record.

I also want to be able to edit the records while browsing so I’m looking for code to make the Update button work.

My plan is to access the form using a button located on a separate sheet which will also contain user guidance.

I should also mention that the pink boxes in the form are not enabled as these cells in the data contain formulas (lookups, index and if’s etc). I don’t have time to code these in VBA even if I could remember how to do it right now. I’ve opted to copy and fill the formulas to several empty rows in these columns as there probably won’t be too many additions to the dataset anyway.

I think I need to find a VBA refresher course and/or buy some books – recommendations welcome – but in the meantime I really hope someone can help me.

Many Thanks.

[protonLeah]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

[KatOpti]

Hi, thanks for letting me know, I'm relatively new to the forum and I should probably read the rules again.

I have changed the title now, will my post be visible now for response.

Many thanks.