Recall the data as it is in the user form to edit and update

[bala04msw]

Dear Experts,

I need your guidance on the following requirements.

I have developed a user form called "SVmainForm", which has lots of data entry tool option like, text box, radio button and combo box. It works well and data stored in excel worksheet called "SVReport". Till here the user from works fine.

Requirement:

1. I want to edit and update the data. For that, i have just made the duplicate user form called "SVeditForm" (from the original user form, which is used for data entry)
2. I want to recall the entered data, which stored in excel worksheet should be in the SVeditForm through with one of the criteria called "Report No."
3. Text box data should be recalled in Text box, Combo box data should be recalled in combo box and Radio button data should be recalled in radio button.
4. Now, based on the requirement, i will edit and update the data.

As simply, i want to recall the data as it is in the data entry form.

Is there any idea? please help me.

Regards

[AlphaFrog]

This example will look for a "Report No." match in column A and return its row number. Then populate the textboxes from values in that row.

Please Login or Register  to view this content.

[bala04msw]

Dear Mr.Alpha,

Thanks for your reply with the codes. I have modified and applied the codes, which you have suggested. The modified codes have been given below.

Actually Data should be recalled in combo boxes, Yes, text boxes are also there as well as radio button options are there. The given codes are not recalled the data in combo boxes. (cbtown and cbstate, those are combo boxes)

Kindly guide me

Please Login or Register  to view this content.

[bala04msw]

Dear Alpha,

Thanks for the code. It really works charm. I did some mistake in the variables and rectified and works fine at all different inputs tools, like tex tbox, combo box and radio button.

Thanks a lot

[bala04msw]

Dear Mr. Alpha,

I think we have missed out "Update Data". Actually We need to update the existing data and save in the same row in the excel worksheet. Could you please help me on this part?

VBA Code for "Update"

Regards