• 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. N

    Display range in list box on check box selection

    hi forum, i had a userform with check boxes and a list box.where in if,i select a check box i want to display a range in the list box,(Range of data from the worksheet).i tried something like the below: Private Sub dc_Click() If dc = True Then Worksheets("back").Cells(1, 11).Value = Plants...
  2. N

    Summary of the expenses.

    hi forum, i m facing some problem with the formula in my worksheet.i had a worksheet with the following data. Date Month Sales Man Amount 01/4/11 Apr'11 A 1504 01/4/11 Apr'11 B 1425 01/5/11 May'11 A 1400 01/5/11 May'11 B 1409...
  3. N

    DO LOOP with CELLS.

    hi, i would like to know how to use the Range or cells property with a Do loop. I had tried the below code,but i m getting "Method of Object_Global failed" error... Sub testdo() Range("A1").Select Do Until cells(15, 0) ActiveCell.Value = "Microsoft Excel" ActiveCell.Offset(1, 0).Select...
  4. N

    Do loop

    hi,i had been learning vba from the past couple of days.i m facing problem in learning the DO loop.I m trying to print the text "MICROSOFT" in the cells A1 until the cell value is "Excel" here is the code i had tried.I could not get the desired result.Please help me where i went wrong.also the...
Back
Top