Use combobox to select a worksheet

[vikass]

i want to prepare a accounting userform,where there are different sheets corresponding to different accounts like wages,salary,expences,sales,received etc.there will be a text box in which amount will be talen ,another text box will take DATE a combo box which will list different sheets i.e. account in which amount will be debited or credited.two buttons for DEBIT and CREDIT,another button to reset the data once entered.How can i link combobox to differnt sheets i.e. accounts, in which user selects to fill data?

Moderator's note: You will get better responses if your title describes what you are trying to do. The word "combobox" doesn't tell us much. Because it is your first post I have given it a better title.

[hulpeloos]

assuming you have the combobox in a userform

Please Login or Register  to view this content.