Hi all and thanks in advance for your help.
What I am trying to do is create a userform to fill a sheet with data. I have a collection of Survey plats and drawings that I nee to be able to find and associate with current projects.
What I have is a user form w/ several comboboxs. Some are easily populated with the .AddItem such as Counties, Direction, Meridian blah...blah...blah.
The one that is giving me fits is the Subdivision. There is too many unknowns involved.
What I picture in my head is a dynamic range (Subdivision) that populates the combobox (easy and done before) and a Command Button for add new next to it that would open a dialog box where I type the new name, select yes/no and it would add to the list for future reference.
Any ideals or direction will be greatly appreciated.
Thanks
What I am trying to do is create a userform to fill a sheet with data. I have a collection of Survey plats and drawings that I nee to be able to find and associate with current projects.
What I have is a user form w/ several comboboxs. Some are easily populated with the .AddItem such as Counties, Direction, Meridian blah...blah...blah.
The one that is giving me fits is the Subdivision. There is too many unknowns involved.
What I picture in my head is a dynamic range (Subdivision) that populates the combobox (easy and done before) and a Command Button for add new next to it that would open a dialog box where I type the new name, select yes/no and it would add to the list for future reference.
Any ideals or direction will be greatly appreciated.
Thanks
