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?

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?

Bhiravi

From the helpfile on "AutoComplete": Turn on or off automatically
completing entries in columns On the Tools menu, click Options, and then
click the Edit tab.

To allow automatic completion, select the Enable AutoComplete for cell
values check box.
To prevent automatic completion, clear the check box.

Hope this helps

Mike Rogers


"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?

Like it's autocompleting your entry for you?

Tools|Options|Edit tab|uncheck "enable autocomplete for cell values"

(I hate this for the same reason!)

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?

--

Dave Peterson

Tools/ Options/ Edit
Uncheck: Enable AutoComplete for cell values.
--
David Biddulph

"Bhiravi" wrote in message
...
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?

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?

Right-click on the Excel logo left of "File" on menu or on left side of title
bar if window is not maximized and select "View Code"

This opens the Thisworkbook module.

Copy/paste the two sets of code into that module.

Save and Close workbook..........reopen.


Gord Dibben MS Excel MVP

On Thu, 21 Dec 2006 11:42:00 -0800, Bhiravi
wrote:

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?