Auto format on worksheet open

**Kearse56** · 09-07-2007, 03:41 PM

I have a select case statement that formats cells based on text typed. I want to apply the same logic to a range of cells when I open the worksheet and select a range. Can someone help with the change I need to the below code?
Muchas gracias

Please Login or Register  to view this content.

**mrice** · 09-07-2007, 03:54 PM

Use the sheet_activae and selection_change events.

Break the target down into individual cells

Please Login or Register  to view this content.

**Kearse56** · 09-07-2007, 04:05 PM

Martin,
I'm not sure I understand. I want to open the worksheet, highlight a range of cells and have them reformatted according to the select case criteria established. Forgive my ignorance. I am very new to this.

Thank you

**mrice** · 09-08-2007, 08:18 AM

Let me check my understanding. What event do you want to trigger the running of the code.

Is is the opening of the sheet and formatting whatever happens to be selected or every time you select any cell. Both sound a bit unlikely.

Or maybe you are after something which runs once you have selected the set of cells that you are interested in and not for others?

**Kearse56** · 09-09-2007, 10:53 AM

The latter.
Once I select a range of cells I want to execute the Select case.

**royUK** · 09-09-2007, 11:08 AM

Is this what you mean?

Please Login or Register  to view this content.

**Kearse56** · 09-12-2007, 09:23 AM

Roy,
Excellent !!! That is exactly what I was trying to do.

Thanks so much.

Auto format on worksheet open

LinkBack

Thread Tools

Rate This Thread

Display

Auto format on worksheet open

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions