Restrict data entry to specified cells
Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance
Hi, I'd like to be able to restrict new data entry to specified cells in a
workbook. I'd like a method to say where data should be added, and then for
that to be inserted at the top of the column of entries, e.g. button or
similar for "click here to add data" or something similar which then opens a
dialogue box where data is added. When click finished or close, the new data
should be automatically added to the top of the list. Is that possible?
.
Relevant Pages
- RE: Deleting Code and saving
... However it IS possible to delete the VBA code even whilst it is running - I ... distributed as an xlt and it creates a document from a data entry page - ... of the workbook to a new workbook without the code and put that out to the ... special values on the report sheet, deletes the data entry sheet (which ...
(microsoft.public.excel.programming) - script to send data from worksheet to multiple workbooks
... I want to create a data entry worksheet that links to multiple ... grades) into the individual workbook for that student. ...
(microsoft.public.excel.programming) - Re: excel to access problem
... This code is placed in "This Workbook". ... After you complete data entry, close the workbook and reopen it, it ... Dim ToErase As Range, EraseRows As Integer ...
(microsoft.public.excel.misc) - Re: Removing VBA from a workbook
... Select entire data entry worksheet/UsedRange).Copy ... create a new workbook ... so i have been working on automating the submission of time cards. ... submitting for. ...
(microsoft.public.excel.programming) - Re: Data entry too slow even with calc set to manual
... its hard to say without analysing the workbook but do you have: ... manual AFTER data entry or using the dropdowns. ... in a cell it can take 2 to 3 seconds before the cell below is selected. ... down lists (the drop down lists were inserted using Data> Validation ...
(microsoft.public.excel.misc) |
|
