Recent Activities

  • Bendfella

    Like (Post)
    Use a Custom NumberFormat - "BD"00000


    1. Select the cell or cells.
    2. Right click and choose Format Cells.
    3. Select Custom.
    4. In the Type list, select an existing format, or type a new one in the box.
    5. To add text to your number format: Type what you want in quotation
  • Bendfella

    Post
    thank you very much Roy, it worked.

    You are our own excel guru
  • CJamesUK

    Replied to the thread Blank cells replace zeros.
    Post
    (Quote from royUK)

    Good Morning Roy
    Yes same workbook, I have tried using the show a zero in cells that have no value in excel options but when I use my email macro it still picks up the zeros so was hoping using this formula would work.
  • royUK

    Post
    You need to restore Application.DispalyAlerts to True.
    What error message are you getting?
  • royUK

    Replied to the thread Excel VBA Button Text Color Change.
    Post
    What kind of button?
  • royUK

    Post
    Use a Custom NumberFormat - "BD"00000


    1. Select the cell or cells.
    2. Right click and choose Format Cells.
    3. Select Custom.
    4. In the Type list, select an existing format, or type a new one in the box.
    5. To add text to your number format: Type what you want in quotation
  • royUK

    Replied to the thread VBA Multiple IF.
    Post
    Have you tried the Calculate event?
  • royUK

    Post
    Hope you get it sorted. Let u know.
  • annasolano

    Wrote a comment on annasolano’s wall.
    Wall Comment
    Patient Engagement Solutions
    We offers state-of-the-art Healthcare patient engagement solutions that improve patient-provider coordination through effective communication channels and support better population health management for better outcomes.

  • Spοck

    Has received the trophy Yearling.
    Trophy
    Reached 1 year of membership at OzGrid
  • Bendfella

    Thread
    Good day

    i want when u type in a number and the number will always have 25364 (five numbers) the letters BD must appear before the numbers.

    so when u type in 25364 in the cell it must show as BD25364

    the cell range is on a specific worksheet and its from…
  • Krishna1257

    Has received the trophy Yearling.
    Trophy
    Reached 1 year of membership at OzGrid
  • omartin

    Thread
    I need to change the text color of a button.

    I know to change the background of a button is:

    btn1.BackColor = vbBlue

    but I don't know the code for just the text.
  • healey

    Has received the trophy Yearling.
    Trophy
    Reached 1 year of membership at OzGrid
  • Hello
    Attached file is the sample file actual data have more than 10K+ rows .... I am trying to write a vba code for below steps for Sheet 1 ... Please note Expected Result is the outcome of this macro

    1: Filter the " B Column" without #N/A value
    2: Replace…
  • davec0864

    Thread
    I've been using code in a worksheet several times every day for over a year and it has always worked until I made what I thought was a simple change. Now the code gives me a "Method "Close" of object '_Workbook' failed". I've checked to make sure I
  • Alfredo Caceres

    Has received the trophy Yearling.
    Trophy
    Reached 1 year of membership at OzGrid
  • KayZee

    Has received the trophy Yearling.
    Trophy
    Reached 1 year of membership at OzGrid
  • Mikey7589

    Has received the trophy Yearling.
    Trophy
    Reached 1 year of membership at OzGrid
  • jrdnoland

    Post
    I commented out the database calls and the classes did seem not to fail as they did before. Guess I'll try adding back the database calls one step at a time and see what's causing it to fail.

    Appreciate you help and insight!