lanhao
07-26-2006, 01:34 PM
Hi there,
I have a form that I am trying to put togehter, adn one of hte things that needs to be included is a little string of code where it will check the list of information, and if it finds a duplicate name, it will popup a msgbox, and stop the userform from putting in the new data. (I'm going to be making a different form for editting existing data).
That's the code I have put together thinking it would work, but it doesn't seem to be registering this function before putting all the info in.
Dim v As Integer
v = 1
For v = 1 To Cells(Rows.Count, "A").End(xlUp).Row
If tbNode.Value = ws.Range("A" & v) Then
MsgBox "This node has already been entered"
End If
Next v
Thanks for the help on this
I have a form that I am trying to put togehter, adn one of hte things that needs to be included is a little string of code where it will check the list of information, and if it finds a duplicate name, it will popup a msgbox, and stop the userform from putting in the new data. (I'm going to be making a different form for editting existing data).
That's the code I have put together thinking it would work, but it doesn't seem to be registering this function before putting all the info in.
Dim v As Integer
v = 1
For v = 1 To Cells(Rows.Count, "A").End(xlUp).Row
If tbNode.Value = ws.Range("A" & v) Then
MsgBox "This node has already been entered"
End If
Next v
Thanks for the help on this