Thanks for letting me join. I'm way over my head and neck deep. LOL
This is for a charity that serves people with disabilities I'm trying to help out.
(Capture 1 Image) I need multiple drop down list that replaces the text of the available selections with a numerical number. For example when the user selects a County from a drop down list the associated County Code is placed in that cell. Same for the Disability and it's code, Service and its code.
(Capture 2 & 3 Image, different tab/sheet) I was able to get it to work once, Capture 2 image cell I30, using some code copied from a Youtube video, Capture 3 image, but have issues trying to make it work again. Probably cause I know nothing on the Visual Basic basics.
The end goal would be to have the user be able to enter clients served by the charity and have these codes populate the spreadsheet that will be sent to the funding authority for quarterly reports. Thanks in advance for any help pointing me in the right direction.![Smile :) :)](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
![Capture 1.JPG Capture 1.JPG](https://www.mrexcel.com/board/data/attachments/113/113938-46f8a03dd97a286135bd0eee49babd65.jpg)
![Capture 2.JPG Capture 2.JPG](https://www.mrexcel.com/board/data/attachments/113/113939-d45d600ba3b53ad385e1b3923e99f293.jpg)
![Capture 3.JPG Capture 3.JPG](https://www.mrexcel.com/board/data/attachments/113/113940-aea2658f9970d2d67671ae2723d443bc.jpg)
This is for a charity that serves people with disabilities I'm trying to help out.
(Capture 1 Image) I need multiple drop down list that replaces the text of the available selections with a numerical number. For example when the user selects a County from a drop down list the associated County Code is placed in that cell. Same for the Disability and it's code, Service and its code.
(Capture 2 & 3 Image, different tab/sheet) I was able to get it to work once, Capture 2 image cell I30, using some code copied from a Youtube video, Capture 3 image, but have issues trying to make it work again. Probably cause I know nothing on the Visual Basic basics.
The end goal would be to have the user be able to enter clients served by the charity and have these codes populate the spreadsheet that will be sent to the funding authority for quarterly reports. Thanks in advance for any help pointing me in the right direction.
![Capture 1.JPG Capture 1.JPG](https://www.mrexcel.com/board/data/attachments/113/113938-46f8a03dd97a286135bd0eee49babd65.jpg)
![Capture 2.JPG Capture 2.JPG](https://www.mrexcel.com/board/data/attachments/113/113939-d45d600ba3b53ad385e1b3923e99f293.jpg)
![Capture 3.JPG Capture 3.JPG](https://www.mrexcel.com/board/data/attachments/113/113940-aea2658f9970d2d67671ae2723d443bc.jpg)