Can I create an input bar?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

borstal - 23 May 2006 09:46 GMT

Hi

Im working on a super basic order sheet and was hoping to include a
locked row at the top of the sheet. I want to be able to add the data
in a set of cells and when full it add it to the worksheet and then
clear the row ready for a fresh set of data.

Ive tried to find some help in the 'help' on excel........:mad:

Can someone help?

Signature

borstal

Reply to this Message

Dave Peterson - 23 May 2006 13:26 GMT

I think that many people would approach this by using
Data|form

or creating a userform.

If you want to try, you can read Debra Dalgleish's notes:
http://www.contextures.com/xlUserForm01.html
and
http://www.contextures.com/xlUserForm02.html

> Hi
>
[quoted text clipped - 12 lines]
> borstal's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=34694
> View this thread: http://www.excelforum.com/showthread.php?threadid=544606

Signature

Dave Peterson

Reply to this Message