Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by plmnb

  1. plmnb

    Change the color inside the cell?

    tranpkp, I have just tested: Cells(6, 5).Interior.Color = RGB(255, 255, 255) Cells(3, 1).Interior.ColorIndex = 0 Both set the corlor to white. However, in the first case, the border of cells(6,5) is losted while in the second one the border still there.
  2. plmnb

    Change the color inside the cell?

    tranpkp, So, what is the difference between cells(1,1).Interior.Color = rgb(0,255,0) and Cells(1, 1).Interior.ColorIndex = 4
  3. plmnb

    Change the color inside the cell?

    So, I need to do both: cells(1,1).Interior.Color=rgb(255,0,0) cells(1,1).Border.Color=rgb(0,0,0) Interior means inside? Why I need to do both?
  4. plmnb

    Change the color inside the cell?

    Hi, I use cells(1,1).Interior.Color=rgb(255,0,0) to change the cell's color.....why the color of the border of the cell also be changed? How to change the cell color only inside not the border?
  5. plmnb

    Using VBA + Outlook to get content of emails

    Hi, Using VBA in Outlook 2000, how to get the content of all emails in folder Inbox?

Part and Inventory Search

Back
Top