Populate data in userform and edit

[surajitbose]

I have created a user form

Please Login or Register  to view this content.

for daily expenses entry. the form populate data into two different worksheets "Database" and "I&E" working perfectly. Now i want to give an administrative right to some user to edit the data.

Please Login or Register  to view this content.

is used for the password and makes visible

Please Login or Register  to view this content.

. this combobox is for populate data again to the userform based on vauchar no.

With my little knowledge I can populate some of the data to the userform but as per as the option Buttons are concerned i am stuck. In

Please Login or Register  to view this content.

if

Please Login or Register  to view this content.

is selected it populates "cash" in 'Mode' column in Database worksheet so if column Mode (I) is "cash" I want

Please Login or Register  to view this content.

to be selected, else if Mode column is "Cheque"

Please Login or Register  to view this content.

will be selected with

Please Login or Register  to view this content.

&

Please Login or Register  to view this content.

visible with the cheque No and Bank name from column 'J' & 'K'.
Secondly

Please Login or Register  to view this content.

is for update the data. Can any one help me with the code to update the data in to

Please Login or Register  to view this content.

and

Please Login or Register  to view this content.

Thanks in advance.
is there any way to protect the Worksheets so that no entry or modification should be done directly but through usrtform.
My

Please Login or Register  to view this content.

is for new entry of catagories

T
hanks again.
please see the attachment

[CRIMEDOG]

Please Login or Register  to view this content.

Use this macro - then sheet will be protected but macros can write into it. (Run the macro then save).

[surajitbose]

Thanks Crimedog

It is working perfectly. I am more concern about the edit part. can you please see to it .

Regards
Surajit

[surajitbose]

dear crimedog,
any help?

[CRIMEDOG]

I am not sure what edit you mean. it does allow your user forms to write into the workbook.

Edit
I see now - administrative rights
highlight the ranges you want them to edit - then choose "allow users to edit" in the review tab. Establish a seperate password for them.
Now when they begin to type into one of the cells: a dialogue box will open requesting a password. Once they have unlocked the range, it will remain unlocked until they save and close.

You can set up multiple ranges with multiple passwords

The main password will remain in effect.