i have attached to this post my Excel workbook to record processed payment vouchers. I have a UserForm1 with a combobox with the label "Currency Type". Upon selection it displays the currency symbol on a Label which subsequently allows the user to type in the amount. On the sheet named "ProceesedPV" are last but three columns bearing the headings of the various currencies. What i want the userform to do is that when a user selects a particular currency from the combobox2 and enters the amount, the entered amount in the textbox16 should be sent to the particular column based on the combobox2 selection. Can this be done or will be glad to receive other alternative as to how this can be done. I just want to avoid the creation of three(3) separate textboxes to do this function. any help? Thanks
Bookmarks