bujaman
10-07-2007, 01:05 AM
I am building a spreadsheet to keep track of my bank accounts and how i move money to and from accounts. I am using a userform with combo boxes and multiple optionbuttons. I have one optionbutton set for account (Wells Fargo Checking, etc.) and another for type of transaction (Deposit, withdraw, transfer). If transfer is selected another combobox becomes active and you can select the account you are transfering to. I want to select an account from that box and when I post the transaction, have it pull the name property value from the selected optionbutton and put it into a cell in excel, anyone have any idea on how to do this? I would love and appreciate any help. Thanks.