Data Entry Problem

[APMercer]

Hi

I'm a newby to VBA and am having problems with a line of code.. its a data entry form
and I have this line of code finding the next available row returning a fault message. (Runtime error 424 Object required)

erow=PriceList.Cells(Rows.Count,1).End(x1Up).Offset(1,0).Row

I also perform calculations on the data once entered into the spreadsheet.. can anyone suggest a line of code
that will format the next free line with my calculations before the data is entered ?

If someone has simple input and extract data forms I can adapt that would be great.

Thanks in advance.

[mwinter]

Please can you upload an example document with all personal information removed.

I have been working on a similar project myself and may be able to assist.

[APMercer]

Thanks for the rapid response.

I've uploaded a page with the code I am having problems with and a sample of the data.

[mwinter]

This is the code i use for a similar project, a live excel version would be much more beneficial for me to help you though instead of a word document, not much help.

Rename the userform to whatever yours is called and then change the sheet name to your sheet, amend the range values.

This formula will insert data into a new sheet called "amends" it will find the next available row, starting it's search at A, it will then enter the data into the relevant column, of that row as per specific below. The data is input from a Form on a seperate sheet (userform1) My data is pulled from a variety of text boxs, combo boxs and such, see below.

Please Login or Register  to view this content.

Hope this helps in some way.

Mike

[APMercer]

I kept getting file too large when I tried uploading the file. I figured there were restrictions on file size to prevent anything other than the simplest files. I'll give it and go and let you know how I get on .

With regards to handling the data if I wanted multiple options of the same product would you enter each variant as a new line or create the options (widths in my file) as options on the same row/entry.

Thanks for your help

Andy

[mwinter]

I would create each option as a NEW line variant.