Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
On UserForm3 I have TextBox1, TextBox2, and TextBox3, and
CommandButton1 named "Delete". On Sheet2 I have a table of data in Range A2:C52. In this table, ColumnA contains Extensions, ColumnB contains Employee Names, and ColumnB contains Email Addresses. On the UserForm3, TextBox1 looks in ColumnA, TextBox2 looks in ColumnB, and TextBox3 looks in ColumnC. What I need is for when the user clicks the "Delete" button on the UserForm, I need the code look on Sheet2 Range A2:C52 to see if there is a match. In this case, a match would mean the value of TextBox1 matches a value of a cell in ColumnA in the table, the Value of TextBox2 matches a value of a cell in ColumnB in the corresponding row, and the value of TextBox3 matches a value of a cell in ColumnC of the corresponding row. If all the values in the textBoxes(textBox 1, 2 and 3) match the values of a cell in Columns A, B, and C in the same row, then I need for that row in the table to be deleted. If the values of all 3 Textboxes do not match values of cells in the same row, then I need for the code not to run and have a message saying "Not Valid" pop up to the user. What is the code to make this happen? Thank you Todd Huttenstine |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
deleting rows conditional... help!!! | Excel Discussion (Misc queries) | |||
how prevent formula in cell from deleting when deleting value???? | New Users to Excel | |||
Deleting a conditional format | Excel Discussion (Misc queries) | |||
deleting a conditional format | Excel Discussion (Misc queries) | |||
Conditional/selective deleting | Excel Programming |