I have created a user formfor 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.UserForm1
is used for the password and makes visibleUserform3
. this combobox is for populate data again to the userform based on vauchar no.combobox1
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. InifUaserform1
is selected it populates "cash" in 'Mode' column in Database worksheet so if column Mode (I) is "cash" I wantoptionbutton1
to be selected, else if Mode column is "Cheque"OptionButton1
will be selected withOptionButton2
&Textbox6
visible with the cheque No and Bank name from column 'J' & 'K'.Combobox4
Secondlyis for update the data. Can any one help me with the code to update the data in toCommandbutton6
andworksheets ("Database")
Thanks in advance.worksheets ("I&E")
is there any way to protect the Worksheets so that no entry or modification should be done directly but through usrtform.
Myis for new entry of catagoriesUserform2
T
hanks again.
please see the attachment
Bookmarks