Maneesh Massey
Member
Hello,
Thanks for the reply. And thanks for the example you gave for the combo boxes. It is exactly what I was looking for. There are a few
other things I am stuck on. I need help. I have attached a file called "UserFormTest" with this reply. Please have a look at the file and Form I made by going to the Visual Basic Editor. All data used in the file is completely fictitious.
The UserForm should have a the following functionality:
User enters PID (AgentID code) into the PID textbox and presses the Find button next to it. The agent's complete details like his name, address, phone, zone, region etc. etc. should be displayed in the Excel worksheet behind the form.
If the user does not know the PID, then he/she selects a District from the district combo box which automatically updates and populates the Sub-District combo box with the sub-districts corresponding to the district chosen. The user selects a sub-district to go into and presses the "Show Data" button which should display all agent information pertaining to the sub-district chosen. The user can make appropriate changes in the Excel sheet behind the form and save the sheet.
The Update Drop Downs button makes ready all the worksheet data, and combo boxes in memory before someone selects an item from the combo boxes. Essentially loads all items in memory but does not display them. I can also get rid of this button if it is a hassle.
The Reset button clears up the text box, combo boxes and the Excel sheet if it is displayed in the background.
The Add New Record button should open another form, which is simply a data entry form in which the user enters data for a New Agent and other details belonging to him/her. Once the Save button is pressed, the second form closes and first form is displayed as a modal form. If the user clicks the cancel button on the second form, control should go back to the first form.
This is basically all I want the application to do.
Can you please help me set this up ? Once I learn how to program this application, I can take things from here and make some more applications.
Appreciate all your help!
~~ Maneesh
Thanks for the reply. And thanks for the example you gave for the combo boxes. It is exactly what I was looking for. There are a few
other things I am stuck on. I need help. I have attached a file called "UserFormTest" with this reply. Please have a look at the file and Form I made by going to the Visual Basic Editor. All data used in the file is completely fictitious.
The UserForm should have a the following functionality:
User enters PID (AgentID code) into the PID textbox and presses the Find button next to it. The agent's complete details like his name, address, phone, zone, region etc. etc. should be displayed in the Excel worksheet behind the form.
If the user does not know the PID, then he/she selects a District from the district combo box which automatically updates and populates the Sub-District combo box with the sub-districts corresponding to the district chosen. The user selects a sub-district to go into and presses the "Show Data" button which should display all agent information pertaining to the sub-district chosen. The user can make appropriate changes in the Excel sheet behind the form and save the sheet.
The Update Drop Downs button makes ready all the worksheet data, and combo boxes in memory before someone selects an item from the combo boxes. Essentially loads all items in memory but does not display them. I can also get rid of this button if it is a hassle.
The Reset button clears up the text box, combo boxes and the Excel sheet if it is displayed in the background.
The Add New Record button should open another form, which is simply a data entry form in which the user enters data for a New Agent and other details belonging to him/her. Once the Save button is pressed, the second form closes and first form is displayed as a modal form. If the user clicks the cancel button on the second form, control should go back to the first form.
This is basically all I want the application to do.
Can you please help me set this up ? Once I learn how to program this application, I can take things from here and make some more applications.
Appreciate all your help!
~~ Maneesh