View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Richard Richard is offline
external usenet poster
 
Posts: 709
Default Unique entries in textbox

Hello,

I have a form that enters data into columns A - O. Column F must be unique.
The sheet is called DataEntry and the textbox is called tSerial. I have
read previous posts regarding similiar scenarios however, I cannot seem to
get it to work. I need the Form to reject a duplicate entry in Column F
(other than blanks), so that a Msgbox appears, but the current data is not
removed or added once the Add Entry button is pressed.

Thanks in advance. . .