Log in

View Full Version : I need help writing VBA code



ChrisBurton
08-05-2015, 02:48 PM
I am new to writing VBA code and would like some help please. I have manage to use a small amount of code and also created a userform and a sheet where data is to be transferred.

Where i need help is once the userform is populated, i select the transfer button and it then transfers the data to a sheet called records.The entries just find the last row beneath the last entered entries.

All 3 combobox`s and textbox must have entries before the data can be transferred.

Is this a possibility?

Thank you

Chris

ChrisBurton
08-05-2015, 03:50 PM
I have since added some code but it places down the first column instead of across the sheet. What changes do i need to make to get the entry to go across the columns in the same row?

Thank you

Ingolf
08-05-2015, 06:21 PM
See in attach.

I renamed ComboBox and buttons and I put a code to retrieve data from ComboBox in table.
Hope it help.

ChrisBurton
08-05-2015, 07:50 PM
Ingolf, yes thank you for help