Recent Activities

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

…

thank you very much Roy, it worked.

You are our own excel guru

(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.

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

What kind of button?

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

…

Have you tried the Calculate event?

Hope you get it sorted. Let u know.

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.

Reached 1 year of membership at OzGrid

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…

Reached 1 year of membership at OzGrid

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.

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…

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…

Reached 1 year of membership at OzGrid

Reached 1 year of membership at OzGrid

Reached 1 year of membership at OzGrid

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!