Capturing data from userform into the workbook

Hi
Can someone help me please to write a code to capture everything from user form into the workbook
I only starting to learn about VBA coding and know a little bit :-) but this is to advance for me...
I need this for work and would appreciate you help.
Thanks

This code will save all your data into row 1 of your spread sheet.

Please Login or Register  to view this content.

An improved and faster method is:-

Instead of saving the data onto the spreadsheet, save it into an array.

Then you can move the data around within the array.

Then write the array into excel. This is one write instruction and therefore fast.

Not really surer what you mean????
Tahnks

Please Login or Register  to view this content.

Hi
Now I am slowly getting it :-)
Is it possible to have a data from the combo boxes and textboxes to appeared in a specific columns?
Also why in some columns it says TRUE and FALSE?
And is it possible to add data from this userform in the next empty row?
I appreciate your help and support.

Just loop through your array and replace the unwanted text with "".

Dimension your array to the maximum column size minus 1. Arrays start at 0, columns at 1.

then manipulate your array before writing it to excel like I demonstrated:-

'Manipulate columns like this:-

Please Login or Register  to view this content.

To write to the next empty row. assuming your column a is always used.

replace this line:-

Please Login or Register  to view this content.

with:-

NextRow = Range("A1").End(xlDown).Offset(1, 0).Row
Range(Cells(NextRow, 1), Cells(NextRow, 13)).Value = myArray

Hi
I am getting the following error with this line of code

Please Login or Register  to view this content.

"Application defined or object defined error"

yes I had that sometimes today.

That line is looking for the first blank row in A, for some reason " A Bug" it selects that last row that excel suports
then it is trying to select the next row to that, hence the error.

The best thing to do is to restart excel

Hi
I have followed your instructions but I am still getting the same error????
Thanks

try replacing that line with

nextrow = Selection.SpecialCells(xlCellTypeLastCell).row

if you still get the error

then delete that line

close excel

re open the file

re-enter the line

After following your instructions I'm getting error with another line of code

Please Login or Register  to view this content.

Please see the example

So you added an image to the userform.


This line needs changing:-

Please Login or Register  to view this content.

Ok we are getting there... It worked ok this time however when it puts the data in the first row first time, the second time I'm trying to do it doesn't record data in the next empty row it replaces data in previous row. does this make sense?

Add

Please Login or Register  to view this content.

to the macro as shown

Please Login or Register  to view this content.

This worked grate and I want to thank you for your help!! Can I ask for 1 more thing? You remember when you have mentioned about manipulating my array to get the data to a specific cells? It didn't work I have tried everything and every time I tried I failed... I am getting data all over the place but this isn't the biggest issue, the biggest problem is that it doesn't record all data from userform only some data plus I am still getting True and False in certain cells how can I fix all does little problems???
Would it be possible to have something that would create a Number in column A, every time new entry is made for example:
1
2
3
4
5
6
and so on...
Thank you and apologize for being a pain...
Dan

I will appreciate anyone's help with the above please.
Another issue I'm having with it is that when I for example do 4 entries and delete them the next entry wouldn't be in next empty row instead data will be in row 4 and continue 5,6,7 and so on however if I delete data again and complete the form then data will be put in row 10,11,12 and so on... This is strange as all above rows are empty??
Thanks