August 1, 2018
Hi, I am new to Excel VBA programming and Looking for assistance with the below requirement:
" Based on a selection from Combox Box, multiple list boxes will be displayed with the data ( product names). The user now will input the values in different text boxes against each of the list boxes. Once we click on the Submit command button, the data to be saved to the respective cells of a different worksheet and the saved data to be locked for further editing. The selection should be clear to allow the user to have a different selection."
Thanks and Regards
October 5, 2010
The description of the problem is too vague with to many steps to allow me to really put together a solution.
You need to supply a workbook with the data for us to have some idea of what we are working with, plus a design of the forms you want.
My gut feel is that this is beyond a simple forum qs that we could provide an answer for and sounds more like a form driven data entry application that would require several hours of development. If you contact us via the Helpdesk we can discuss further.