Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup Value in an External Spreadsheet | Excel Discussion (Misc queries) | |||
Working spreadsheet highlighting function for Excel 2007 | Excel Worksheet Functions | |||
Need to insert file modified date of Excel spreadsheet in a cell | Excel Discussion (Misc queries) | |||
How do I insert the sigma symbol in an Excel spreadsheet? | Excel Discussion (Misc queries) | |||
Challenging Charting | Charts and Charting in Excel |