Search:

Type: Posts; User: ipbr21054; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.04 seconds.

  1. Re: Code to work to specific row and not whole row

    I understand what you have put or i think i do BUT i still see the msgbox.
    Let me tell you what i do.

    With the code shown below i open workbook & slect the worksheet MC LIST
    I then select cell...
  2. Replies
    1
    Views
    22

    Update code for userform source

    Hi,

    I have a userform which has Comboboxes for which i select an item from the drop down list.
    Once all the boxes are complete i then click my transfer button to entere it on my worksheet.
    ...
  3. Re: Code to work to specific row and not whole row

    What did i do wrong as i still get the msg appear.




    Private Sub Worksheet_Change(ByVal Target As Range)
    Dim c As Range
    Dim lr As Long
    lr = Cells(Rows.Count, "B").End(xlUp).Row...
  4. Re: Code to work to specific row and not whole row

    Hi,

    Its B
  5. Code to work to specific row and not whole row

    Afternoon,

    Working code in use shown below.

    Currently this code operates the whole of column B where i would like it to stop at the last row.
    So currently my last row with data in is row 19...
  6. Replies
    4
    Views
    96

    Re: Part of my code has stopped working

    You are correct.

    I didnt see it before as nothing was there but the following now works,thanks



    =IFERROR(IF(INDEX(DATABASE!W:W,$H$13)=0,"",INDEX(DATABASE!W:W,$H$13)),"")
  7. Replies
    4
    Views
    96

    Re: Part of my code has stopped working

    I have looked for code that would copy / paste the required values but so far no luck.
    I have look for code on the INV & DATABASE sheet.
    Ive even looked through every module code but nothing.
    ...
  8. Replies
    2
    Views
    47

    Re: Worksheet activate question

    Thanks very much
  9. Replies
    2
    Views
    47

    Worksheet activate question

    Morning,

    I have this is place at present.



    Private Sub Worksheet_Activate()
    Range("G13").Activate
    End Sub
  10. Replies
    4
    Views
    96

    Part of my code has stopped working

    Morning,

    I have a worksheet called INV that when i select the drop down arrow in cell G13 i see a list of customers names.
    These names are on another worksheet called DATABASE of which is in the...
  11. Replies
    14
    Views
    216

    Re: Edit for existing working code

    Thanks,
    I think there is a bit of lag in between messages.

    Your last code worked.

    Thanks
  12. Replies
    14
    Views
    216

    Re: Edit for existing working code

    Am I supposed to use something like

    With ThisWorkbook.Worksheets("MC VIN”)

    ?
  13. Replies
    14
    Views
    216

    Re: Edit for existing working code

    I now click on a item in the listbox but see a RTE Method Range Of Object Global Failed.
    I debug andd se the following in yellow.



    Code: [View]


    Private Sub ListBox1_Click()
    Range("E"...
  14. Replies
    14
    Views
    216

    Re: Edit for existing working code

    Hi,
    I have put in use the code below as advised.



    Private Sub TextBox1_Change()
    Dim r As Range, f As Range, Cell As String, added As Boolean, sh As Worksheet
    Set sh = Sheets("MC VIN")
    ...
  15. Replies
    14
    Views
    216

    Re: Edit for existing working code

    You will need to check the code below but i see in the listbox the same as in worksheet





    Private Sub TextBox1_Change()
    Dim r As Range, f As Range, Cell As String, added As Boolean, sh As...
  16. Replies
    14
    Views
    216

    Re: Edit for existing working code

    Hi,

    With that code i then see the following.
    So if i search AB02 the results shown in the listbox doesnt match the database.

    In the listbox i should see,
    VIN MODEL PREFIX
    HONDA MODEL
    YEAR...
  17. Replies
    14
    Views
    216

    Re: Edit for existing working code

    Any advice please.
  18. Re: Search box code doesnt select correct cell on worksheet

    Any advice please.
  19. Re: Return to top of page icon always in users view on worksheet

    I froze the top two rows like you mentioned.
  20. Replies
    14
    Views
    216

    Re: Edit for existing working code

    Hi,

    Here is a better explantion of what i would like to happen.

    As you can see in my example i have searched for AB02
    The results are shown in the lisbox & the AB02 options are shown.

    BUT I...
  21. Re: Search box code doesnt select correct cell on worksheet

    Hi,
    I have found the issue but need some advice if i may to fix it.

    If in my database there is only 1 occurance of say AZ1 then when i search for AZ1 i select it in the listbox & i am taken to it...
  22. Replies
    14
    Views
    216

    Edit for existing working code

    Morning.

    The code below works but looking for an edit please.
    I type AB02 in the search box & the listbox returns the results from column E
    I wish to now type AB02 but in the listbox be able to...
  23. Re: Search box code doesnt select correct cell on worksheet

    Just an update.
    i found this code which now takes me to column E
    The issue now is finding why it doesnt select the correct item of which i had selected from the list box



    Private Sub...
  24. Return to top of page icon always in users view on worksheet

    Hi,

    I have a long list in column E which is say 1000 + results down the page.

    I am in need of a Return to top of page code BUT a floating type if possible.

    I mean the Return to top icon...
  25. Search box code doesnt select correct cell on worksheet

    Morning,


    I have taken this code from another worksheet & made the edits for it to work on my new sheet.
    I type in the search box say AB & all the results with AB are shown in the listbox.
    I...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4