+ Reply to Thread
Results 1 to 11 of 11

Textbox.value from form, search on sheet2, Coloum B, and delete entire row?

  1. 06-28-2012, 12:09 PM #1
    JDExcel
    JDExcel is offline
    Registered User
    Join Date
    05-17-2012
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    10

    Textbox.value from form, search on sheet2, Coloum B, and delete entire row?

    I have a form with a textbox that i enter in an IMEI number into. When i hit save, i want to find the IMEI number on sheet2 called Inventory and the IMEI numbers in coloum B, and delete the entire row. Please help!
    Reply With QuoteRegister To Reply
  2. 06-28-2012, 12:58 PM #2
    Tinbendr
    Tinbendr is offline
    Forum Expert Tinbendr's Avatar
    Join Date
    06-26-2012
    Location
    USA
    MS-Off Ver
    Office 2010
    Posts
    2,125

    Re: Textbox.value from form, search on sheet2, Coloum B, and delete entire row? 

    Please Login or Register  to view this content.
    Last edited by Tinbendr; 06-28-2012 at 01:36 PM.
    David
    (*) Reputation points appreciated.
    Reply With QuoteRegister To Reply
  3. 06-28-2012, 01:09 PM #3
    JDExcel
    JDExcel is offline
    Registered User
    Join Date
    05-17-2012
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    10

    Re: Textbox.value from form, search on sheet2, Coloum B, and delete entire row?

    This does not work, get an error unvalid or unqualified reference at ".Rows"
    Also, can we make this a method?
    Last edited by JDExcel; 06-28-2012 at 01:19 PM.
    Reply With QuoteRegister To Reply
  4. 06-28-2012, 01:38 PM #4
    Tinbendr
    Tinbendr is offline
    Forum Expert Tinbendr's Avatar
    Join Date
    06-26-2012
    Location
    USA
    MS-Off Ver
    Office 2010
    Posts
    2,125

    Re: Textbox.value from form, search on sheet2, Coloum B, and delete entire row?

    Quote Originally Posted by JDExcel View Post
    This does not work, get an error unvalid or unqualified reference at ".Rows"
    Try it again. Added the reference.
    Also, can we make this a method?
    I don't understand this.
    Reply With QuoteRegister To Reply
  5. 06-28-2012, 02:03 PM #5
    JDExcel
    JDExcel is offline
    Registered User
    Join Date
    05-17-2012
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    10

    Re: Textbox.value from form, search on sheet2, Coloum B, and delete entire row?

    Mismatch error


    Please Login or Register  to view this content.
    Last edited by JDExcel; 06-28-2012 at 02:06 PM.
    Reply With QuoteRegister To Reply
  6. 06-28-2012, 03:14 PM #6
    JDExcel
    JDExcel is offline
    Registered User
    Join Date
    05-17-2012
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    10

    Re: Textbox.value from form, search on sheet2, Coloum B, and delete entire row?

    I added the code that I edited that you gave so you could see my naming convention.
    Reply With QuoteRegister To Reply
  7. 06-28-2012, 03:17 PM #7
    Tinbendr
    Tinbendr is offline
    Forum Expert Tinbendr's Avatar
    Join Date
    06-26-2012
    Location
    USA
    MS-Off Ver
    Office 2010
    Posts
    2,125

    Re: Textbox.value from form, search on sheet2, Coloum B, and delete entire row? 

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  8. 06-28-2012, 03:37 PM #8
    JDExcel
    JDExcel is offline
    Registered User
    Join Date
    05-17-2012
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    10

    Re: Textbox.value from form, search on sheet2, Coloum B, and delete entire row?

    Still not working, no errors though.
    Reply With QuoteRegister To Reply
  9. 06-29-2012, 10:57 AM #9
    JDExcel
    JDExcel is offline
    Registered User
    Join Date
    05-17-2012
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    10

    Re: Textbox.value from form, search on sheet2, Coloum B, and delete entire row?

    Still not working, please help!
    Reply With QuoteRegister To Reply
  10. 06-29-2012, 11:20 AM #10
    JDExcel
    JDExcel is offline
    Registered User
    Join Date
    05-17-2012
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    10

    Re: Textbox.value from form, search on sheet2, Coloum B, and delete entire row?

    I have tried this as well. still nothing is working.

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  11. 06-29-2012, 02:17 PM #11
    Tinbendr
    Tinbendr is offline
    Forum Expert Tinbendr's Avatar
    Join Date
    06-26-2012
    Location
    USA
    MS-Off Ver
    Office 2010
    Posts
    2,125

    Re: Textbox.value from form, search on sheet2, Coloum B, and delete entire row?

    Step through this code with F8 and hover with the mouse over the different objects and see what they're returning.

    Other things to check:
    Go to immediate window and type Worksheets("Inventory").Range("IMEIRange").select and make sure the range IS selected.
    Type ? Me.IMEITextBox.Value It should return the value in the textbox. What is ME? Is it a userform or a textbox on a sheet? You may have to specify ME. e.g. Sheet1.IMEITextBox.Value or Userform2.IMEITextBox.Value
    The default Find is for the Whole word. Are there any trailing spaces on the IMEI numbers in the column? If so, maybe switch the Find to LookAt:=xlPart
    Last edited by Tinbendr; 06-29-2012 at 02:21 PM.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1