Skip a cell that contains data

[slowdiver]

Help! I'm writing a spreadsheet that uses a macro and input boxes t
allow you to input product details relating to products for sale
Column A contains the product number, then the macro automatically tab
across for you to input other data; product name, cost price etc int
appropriate cells in the same row. At the moment, the user must specif
the starting cell in column A to input the new product number then th
macro simply selects the next cell relative to the starting cell. wha
I would like to do is create a little piece of code that means that i
there is data already in the cell in column A, then the macro wil
automatically skip down to the next cell, until the program selects a
empty cell.

This should be fairly easy, but I simply don't know enough about VBA t
make it happen
Can anyone help me please?

Many thanks

 

[Dave Peterson]

You may not need to know anything about VBA.

You could see if Data|Form worked for you. It might be all that's necessary.

If you need more, you may want to look at John Walkenbach's enhanced dataform:
http://j-walk.com/ss/dataform/index.htm

And if you want to create your own, then Debra Dalgleish has a get started with
userforms:
http://contextures.com/xlUserForm01.html

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm