Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can I create an input bar?
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........ Can someone help? -- borstal ------------------------------------------------------------------------ borstal's Profile: http://www.excelforum.com/member.php...o&userid=34694 View this thread: http://www.excelforum.com/showthread...hreadid=544606 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can I create an input bar?
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 borstal wrote: 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........ Can someone help? -- borstal ------------------------------------------------------------------------ borstal's Profile: http://www.excelforum.com/member.php...o&userid=34694 View this thread: http://www.excelforum.com/showthread...hreadid=544606 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Message Input with link to different work sheet | New Users to Excel | |||
Message Input with link to different work sheet | New Users to Excel | |||
Input Box | Setting up and Configuration of Excel | |||
Row filtering based on input box entry (column heading) | Excel Worksheet Functions | |||
Create a tabular control | Excel Discussion (Misc queries) |