Hi is it possible to add a combo list to an input box macro
Im using the following macro, but Id like column C to have the input options of; Invoice Payment, Refund, Personal Deposit or Sale of Assets. instead of a generic option to write text.
Would I do this with a combo box or list built into the iput box or another way maybe? any help would be appreciated.
ps 3rd Range set down is the bit that needs changing, and will cause an error as it is.
Also, my database is made up of 6 sheets, which help to create and log invoices, customer details and expenses details.
I intend to make it as automatic as possible, nut am unsure how to change between sheets when writing the macros?
I have tables on two sheets which are filled in with parts of the same series of information ie. Invoice number, date and value are on both, and customer name and address is on one. If possible I'd like to use one macro to do this rather than the two I currently use. so say I want to have input boxes in Sheet 1 columns A through D as per above and then similarly Sheet 2 Columns A, B, E, F & H, how do I do this.
Many thanks for any help that can be given.
Im using the following macro, but Id like column C to have the input options of; Invoice Payment, Refund, Personal Deposit or Sale of Assets. instead of a generic option to write text.
Would I do this with a combo box or list built into the iput box or another way maybe? any help would be appreciated.
ps 3rd Range set down is the bit that needs changing, and will cause an error as it is.
HTML:
Sub AddIncomingPayment()
Range("A2").End(xlDown).Offset(1, 0).Select
ActiveCell.FormulaR1C1 = InputBox("Date of Incoming Payment")
Range("B2").End(xlDown).Offset(1, 0).Select
ActiveCell.FormulaR1C1 = InputBox("Value of Incoming Payment")
Range("C2").End(xlDown).Offset(1, 0).Select
ActiveCell.FormulaR1C1 = ComboBox1.AddItem Cells(I, "Z")
Range("D2").End(xlDown).Offset(1, 0).Select
ActiveCell.FormulaR1C1 = InputBox("Invoice Reference")
Also, my database is made up of 6 sheets, which help to create and log invoices, customer details and expenses details.
I intend to make it as automatic as possible, nut am unsure how to change between sheets when writing the macros?
I have tables on two sheets which are filled in with parts of the same series of information ie. Invoice number, date and value are on both, and customer name and address is on one. If possible I'd like to use one macro to do this rather than the two I currently use. so say I want to have input boxes in Sheet 1 columns A through D as per above and then similarly Sheet 2 Columns A, B, E, F & H, how do I do this.
Many thanks for any help that can be given.