Thanks a lot for your response, I have a wuestion for you regarding using the
VB, how would I enter that into the spreadheet?
"stumac" wrote:
Hi Bhiravi, you can go into Tools, Options, Edit, and deselect the enable
autocomplete. This would need to be done on all machines where the form is
used. Alternatively you could put some vb in:
Private Sub Workbook_BeforeClose(Cancel As Boolean)
Application.EnableAutoComplete = True
End Sub
Private Sub Workbook_Open()
Application.EnableAutoComplete = False
End Sub
Just to check when you say form are you referring to a formatted worksheet
that looks like a form? If so you can set up the data validation to only
allow the values Y & and N, then even though it will suggest an auto complete
it wont allow the user to continue with that value.
Hope this helps
Stu
"Bhiravi" wrote:
I have a form set up to accept Y or N values input by the user. However, when
the user puts in an N value, the spreadsheet auto enters a value beginning
with N that was entered into another cell. Ie. it is auto inputting from
memory I'm assuming? How do I erase this, so that when the user puts in the
input, Excel does not assume what the user is typing?