An Easier Way?

[jabryantiii]

I while ago, I was looking for a way to accomplish conversions, when someone pointed out that Excel has built-ins that do this very task. The attachment is the end product of my original inquiry. I am not sure if there is an easier way to do what I did, but if there is I am open to suggestions.

[shg]

That's a nice demonstration of dependent data validation.

It would be a kindness if you'd unprotect the one sheet and unhide the other so other people can see what you did.

[Leith Ross]

Hello shg,

In the ThisWorkbook module you will find...

'Created By James A Bryant III
'March Sixteenth Twenty Ten
'Conversion Table
'Password Protected - Password

[teylyn]

Guys, you're slipping!

jabryantiii,

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.

[royUK]

Also,not sure why this has been posted here,I think it should be in Development Testing

[teylyn]

This post surely has one of the highest mod concentrations. 1 red card, four comments (before this one), all different mods.