| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
restrict entry in a textbox to a range of values
Thanks for your replys everyone, though I haven't quite got it working yet. I should have been more specific, but Tom, you assumed correctly that this is a textbox as part of a form. I have successfully protected the field to only allow numerics, and have restricted the maxlength of the field. I have yet to restrict to the values I stated earlier. I changed 'TextBox1' to my assigned field name, 'txtBAN', however when I run the form the debugger does not like the line: txtBAN.Activate Any additional help would be most appreciated. Dillonstar -- Dillonstar ------------------------------------------------------------------------ Dillonstar's Profile: http://www.excelforum.com/member.php...fo&userid=1814 View this thread: http://www.excelforum.com/showthread...hreadid=159534 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Restrict data entry to specified cells | Excel Worksheet Functions | |||
| Ideas on how to restrict a entry | Excel Discussion (Misc queries) | |||
| How to restrict entry or color the field | Excel Discussion (Misc queries) | |||
| Restrict entry types | Excel Discussion (Misc queries) | |||
| can i restrict data entry from certain columns | Excel Discussion (Misc queries) | |||
![Dillonstar[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
