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

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

Many thanks.


--
slowdiver
------------------------------------------------------------------------
slowdiver's Profile: http://www.hightechtalks.com/m778
View this thread: http://www.hightechtalks.com/t2338065

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

slowdiver wrote:

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

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

Many thanks.

--
slowdiver
------------------------------------------------------------------------
slowdiver's Profile: http://www.hightechtalks.com/m778
View this thread: http://www.hightechtalks.com/t2338065

--

Dave Peterson