• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. A

    Userform Update VBA code not working after search result

    Good Evening Members I am Building a user form to store my contacts.By using the user form I can edit,search,view previous or next contact or add new contact There is a command button "Add" which on clicking updates sheet with any modification made on user form.This Button works beautifully when...
  2. A

    Copy Visible Range and paste to Visible Range of another sheet

    I have a database in sheet 2 which has certain rows hidden.I want to copy this data to sheet 1 which also has certain rows hidden but hidden rows are different on both sheets. I have this macro which copies visible data from sheet2 to sheet 1 then sheet1 printout is taken but since hidden rows...
  3. A

    Update Visible cells in a column with Listbox items

    I have this workbook where Sheet ("OPD") has the Database Sheets("Detail") displays Data based on VLookup formula using K9 value It has userform Bloodfrm having Listbox1 which should update Sheets("Detail").Range K18:K54 with selected values.Sheets Detail has some blank rows which are hidden...
  4. A

    Update ActiveRow with Visible Cells only

    I have a Prescription Sheet containing Reports List in Range K18:K54.With Every new prescription all blank rows in used range are hidden using VBA. Report List is added to visible cell in Range K18:K54 using a List Box Now I want to macro code to update Active Row in Sheet OPD with visible cell...
  5. A

    Exel VBA to search matching TextBox value in column A not Working

    Private Sub CommandButton25_Click() Worksheets("OPD").AutoFilterMode = False Dim lastRow As Long Dim FoundCell As Range Dim Search As String Search = VisitDate.Value Set FoundCell = Sheets("OPD").Columns(1).Find(Search, _...
  6. A

    Combobox Listitems date value not displayed properly

    With Sheets("OPD") Set rVisibles = .Range("A2", .Cells(Rows.Count, "A").End(xlUp)).SpecialCells(12) End With For Each rCell In rVisibles rCell.Value = Format(rCell.Value, "dd/mm/yyyy hh:mm AM/PM") Me.DateAdded.AddItem rCell.Value Next rCell I have this Database which contains...
  7. A

    Combobox change event not working with date change

    I have a database showing visitor names in Column B and their visit date/time in Column A Private Sub ComboBox1_Change() For Each Cell In Range("A1:A10") If Cell.Value = Me.ComboBox1.Value Then Cell.Offset(0, 1)..Select End If Next End Sub .I am trying to...
  8. A

    individual page no for each Subtotal page break section

    I have a Excel spreadsheet which prepares the payment of visiting doctors. Entire data of a month or within two date range is selected and then Total of each Doctor is prepared using Subtotal function with page breaks at each subtotal.Centre Footer of each page is formatted to give current page...
Back
Top