Userform data entry

**stevipop** · 11-27-2014, 01:24 PM

Hi all, it's been a long time since I've used Excel (pre ribbon), but I've managed to dig a hole for myself and wondered if someone could throw me a rope.

We have a spreadsheet at work that they duplicate each year for recording some 800+ batches of material. The first record on the spreadsheet begins at C3 and goes through to BJ3, to include the many components within each batch. Now, because we're a bit slack in the foundry this week I was asked to jump on board and try to improve the sheet. Like an idiot I suggested that a userform for data entry might be better than tabbing from left to right across the thing, and hence got lumbered with it despite my protests. I've researched here and other sources and I think I'm on the way but would appreciate any guidance anyone can give.

I've created the userform and it opens on a double-click in any empty cell in column C. Basically I need the form to look for the first empty row in column C and then add all the user input from the form into that row. Also, can data transfer be achieved using code such as;

Please Login or Register  to view this content.

Sorry to be a pain,

Steve.

**Norie** · 11-27-2014, 01:30 PM

Steve

Sounds pretty straightforward, and the code you've posted looks about right, all it's really missing is something to find the next empty row.

For example.

Please Login or Register  to view this content.

PS Can you add code tags when posting code?

**stevipop** · 11-27-2014, 04:12 PM

Thanks Norie, I'd seen code for A:A and finding the next empty row, but couldn't work out how to apply it to a specific column as a starting point. Is this known as an offset, or am I mixing that up with something else?

Sorry about the gaff with the code tags. I've edited my first post to include them, is that OK?

I'd just started to get into the coding side many moons ago but that aspect of the job changed and I went back on the tools and dropped Excel. I should've persevered really because I did enjoy it, but 5 years is a long time and they put a ribbon in there somewhere which hasn't helped, lol.

Anyway, thanks again,

Steve.