Categorising with the use of Forms with Buttons

Hi all,

I have an enormous task ahead and I'm hoping someone could point me in the right direction.

What I have is a list of words (column A) that I need to assign relevance [y/n] (column B) then prioritise high, medium or low [h,m,l] (column C).

I'd like to create a form with keyboard shortcuts to speed up the process. Does anyone know of a post that might already have address a similar requirement that I might look at?

Unfortunately the words are not easy to categorise, so I can't really automate the process (God knows I've tried).

Cheers,

3/5

[edit] I've done some looking into using forms to achieve this, but it seems quite complicated (I'm not familiar with VBA). If you could point me in the direction of some recommended reading based on what I would like do (example attached) that would be great. I can take my time with it, I do this kind of stuff semi-regularly for my job. Thanks.

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 on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

Once you have edited your title, attach a sample workbook for somebody to work with

Originally Posted by davesexcel

Once you have edited your title, attach a sample workbook for somebody to work with

Thanks for adjusting the title, now the helper workbook? Click GO ADVANCED and use the paperclip icon to post up a desensitized copy of your workbook.