BIGMOOSE88
New Member
- Joined
- Jun 3, 2010
- Messages
- 13
Hey Guys & Gals I have a bit of a challenge here and was wondering If you could help me...
I have looked all over the internet for a solution to my problem but found half the solution in each workbook (funny ain't it?)![Big grin :biggrin: :biggrin:](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
I am trying to have a drop down validation so when I click it once, appears a combo box with an autocomplete feature, at the same time if whatever I am entering inside the cell doesnt exist in the source list I would like it to be added as well as an update to the list. But I need the source lists and data to be in vba and not in the sheet for security reasons.
Like I said before its a bit of a challenge for me to get both these features in one workbook but here they are below:
http://www.contextures.com/DataValListAddSort_Multi.zip
http://www.contextures.com/DataValComboClickDepend.zip
Thanks so much for your time!!
I have looked all over the internet for a solution to my problem but found half the solution in each workbook (funny ain't it?)
I am trying to have a drop down validation so when I click it once, appears a combo box with an autocomplete feature, at the same time if whatever I am entering inside the cell doesnt exist in the source list I would like it to be added as well as an update to the list. But I need the source lists and data to be in vba and not in the sheet for security reasons.
Like I said before its a bit of a challenge for me to get both these features in one workbook but here they are below:
http://www.contextures.com/DataValListAddSort_Multi.zip
http://www.contextures.com/DataValComboClickDepend.zip
Thanks so much for your time!!