Morning!
Relatively new to userforms in vba, but I have managed to create a form that controls users input of data into an excel database. I have called this an 'Add New data' function. Now I would like to have an 'Edit Excisting Data' and 'Delete excisting Data' Function. I have studied some solutions on different forums, but after struggeling a bit I figured I should post a request here to get some help on my specific case.
I have designed a userform with a Search frame containing a textbox for search text and a 'Search' command button. When doing the search I want it to fill in the different fields in frame no. 2 called 'Data'. This frames has all the same fields as the userform that I have created for the 'Add New Data' function. I want this to be filled with information based on the search.
Any idea how to do this?
Help is greatly appreciated!
Magneto
Relatively new to userforms in vba, but I have managed to create a form that controls users input of data into an excel database. I have called this an 'Add New data' function. Now I would like to have an 'Edit Excisting Data' and 'Delete excisting Data' Function. I have studied some solutions on different forums, but after struggeling a bit I figured I should post a request here to get some help on my specific case.
I have designed a userform with a Search frame containing a textbox for search text and a 'Search' command button. When doing the search I want it to fill in the different fields in frame no. 2 called 'Data'. This frames has all the same fields as the userform that I have created for the 'Add New Data' function. I want this to be filled with information based on the search.
Any idea how to do this?
Help is greatly appreciated!
Magneto
