Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
FORM ENTRY OUTSIDE OF RANGE SPECIFIED
I am trying to set up some data entry by using the form button, but in trying
to enter data in the middle of the worksheet I get a message saying "the command could not be completed by using the range specified. Select a single cell within the range and try the command again". Any ideas or help would be appreciated! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
FORM ENTRY OUTSIDE OF RANGE SPECIFIED
Hi Don.
In EXCEL 2007 I have just set up a small set of data in cells G 17 to I 22. Three solumn names a- Member Name Date Joined Amount Paid I have then filled 5 rows with data beneath those column names. If I then click in cell G 17 (containing the Member Name field header) and click on my Form button (set up in the Quick Access Toolbar) - Form launches corrrectly. Seems to be working OK for me so do not seem to be able to re-produce the problem you are having. If my comments have helped please hit Yes. Thanks. "Don Hills" wrote: I am trying to set up some data entry by using the form button, but in trying to enter data in the middle of the worksheet I get a message saying "the command could not be completed by using the range specified. Select a single cell within the range and try the command again". Any ideas or help would be appreciated! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Entry Form | Excel Discussion (Misc queries) | |||
data entry form | Excel Discussion (Misc queries) | |||
Data Entry Form | Excel Discussion (Misc queries) | |||
Data Entry Form | Excel Worksheet Functions | |||
data entry form | Excel Discussion (Misc queries) |