Link text Box to Combobox in Userform and autoupdate database

Hi,

I am pretty new to VBA programming. I am new to programming of any kind all together. However, I am required to prepare an excel userform in which a user can select a value from the drop down combobox and the text box is linked to the corresponding column. The combobox gets its value from a database in the same sheet. Further if the value is not present, user can type the value in both the boxes. I have tried to do it myself, seeking help from various forums but m not able to do it.

Please Help me with this.

P.S. would it be possible to add the value in the data base automatically, if it is typed by the user.

Please Login or Register  to view this content.

Thanks.

hi abhiD,
as an option try this and see if it helps you!

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

hi abhiD,
thank you for the rep! hope it helped you!
If your problem is solved, please say so clearly, and mark your thread as Solved:
Click the Edit button on your first post in the thread,
Click Go Advanced, select [SOLVED] from the Prefix dropdown, then
click Save Changes.

abhid, did you try to add something (what you did not find in yr combobox) and then click ok button?!
I tested it with "123", which is not listed, and clicked ok, "123" and the "aaa", "bbb" (for both textboxes) are sent to yr sheet!
or...did I miss something?

@john

Ya.. i checked it again, its working, i was trying to be overtly smart by using a check box..!:P
thanks for the help man..!

and i am not able to edit the first post hence cannot make it solved. I dunno why is that happening. Will mail the forum regulators regarding this..!
thanks newes.

you're welcome!