how to insert VB into a spreadsheet
 

I have a form into which users have to input a Y or N value. However, when
the user hits N, the form auto completes to add a value in the form that
begins with N. ALl i need is for it to stop at the N the user inputs. I
understand I have to input some sort of VB code to take effect at startup -
to prevent autocomplete, so that I dont have to physically go to every system
and disable autocomplete. How do I go about doing this?

how to insert VB into a spreadsheet
 

Bhiravi

Please review your previous post, you have six answers there!!!

Mike Rogers

"Bhiravi" wrote:

I have a form into which users have to input a Y or N value. However, when
the user hits N, the form auto completes to add a value in the form that
begins with N. ALl i need is for it to stop at the N the user inputs. I
understand I have to input some sort of VB code to take effect at startup -
to prevent autocomplete, so that I dont have to physically go to every system
and disable autocomplete. How do I go about doing this?

how to insert VB into a spreadsheet
 

See response at your other thread on same subject,


Gord Dibben MS Excel MVP


On Thu, 21 Dec 2006 12:03:01 -0800, Bhiravi
wrote:

I have a form into which users have to input a Y or N value. However, when
the user hits N, the form auto completes to add a value in the form that
begins with N. ALl i need is for it to stop at the N the user inputs. I
understand I have to input some sort of VB code to take effect at startup -
to prevent autocomplete, so that I dont have to physically go to every system
and disable autocomplete. How do I go about doing this?