userform to input data

Hi,

I have an excel file with a userform and this userform needs to input data into specific columns. How do I code it such that it will appear the way it is in the attached file? Can someone please help me with it.

bqheng,

If you don't get this resolved by this time tomorrow, I will try to help you out. I have created 2 user forms that do something similar to what you are trying to accomplish and I will have to modify them a bit to do what you want. Once I have it complete, I will attach it for you.

Hi, Thank you for help. The info goes to where I want it to be, but it will override the previous info if i try entering another set of data. Can you help me with that?

I thought you might want to keep a running sheet and have it keep the old info so I have already been looking into it. There is a way to do this, I use it on one of my user forms. The problem I am having is that some of the cells are merged so it has me a bit baffled at the moment. I will keep working with it.

Hi, nice to hear from you and hope you will be able to overcome the problem. Will keep checking in to see if there's progress. Thanks alot

You're welcome. I have made some progress, but it's not 100% yet. I can get the 1st 2 submissions to work correctly, but the ones after that go haywire, haven't figured out why....yet.

Give this one a try -

Please Login or Register  to view this content.

Never mind, I thought I had it, but its still not quite right. Sorry about that.

One more try for today. Hopefully this one will work for you. There will be a few extra spaces between each set, working on getting that down to 1 or no spaces.

Please Login or Register  to view this content.

hello!! how have you been? was away for a while so didn't get to try your codes until now. It looks promising, hope you will be able to solve this problem