Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
textbox value validation
In sheet1 I have a user form named 'frmEmployee' and also a 'sheet2
which is the employees' database. One of the tasks is to enter data fo a new employee. The primary key is the ID number of each employee. T avoid entering an existing employee's data, I want a code to use i 'frmEmployee' . So, when I enter a number in the textbox 'ID_Number' t lookup in 'sheet2' (where employee's data is) and if this number exist to stop the data entry procedure and show the message "this ID numbe exists etc...". Thank -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
textbox value validation
In sheet1 I have a user form named 'frmEmployee' and also a 'sheet2'
which is the employees' database. One of the tasks is to enter data for a new employee. The primary key is the ID number of each employee. To avoid entering an existing employee's data, I want a code to use in 'frmEmployee' . So, when I enter a number in the textbox 'ID_Number' to lookup in 'sheet2' (where employee's data is) and if this number exists to stop the data entry procedure and show the message "this ID number exists etc...". Thanks --- Message posted from http://www.ExcelForum.com/ Access would be better for this... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Textbox validation | Excel Discussion (Misc queries) | |||
Bypass Textbox Validation | Excel Programming | |||
Textbox validation | Excel Programming | |||
textbox validation | Excel Programming | |||
putting validation to TextBox in the userform | Excel Programming |