Posted to microsoft.public.excel.programming

spreadsheetlady spreadsheetlady is offline

external usenet poster

Posts: 11

Worksheet_Change?

Hi,
I'm trying to automatically open a Form when a target cell contains an exact
text.

Example:
IF cell A1 says: "Oranges"
THEN
Open Form1.

I've only opened Forms using command buttons.
I was thinking maybe using Sub Worksheet_Change to do this?

If cell A1 says anything else, (false) Do not open Form1.

Thank-you in advance
Amy

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Worksheet_Change help	Ayo	Excel Programming	6	April 29th 09 03:30 AM
Worksheet_Change	General Specific	Excel Programming	5	June 24th 08 05:20 PM
worksheet_change vs. calculate, and worksheet_change not running	Tom Ogilvy	Excel Programming	1	July 14th 03 02:51 AM
worksheet_change vs. calculate, and worksheet_change not running	Ross[_5_]	Excel Programming	0	July 13th 03 04:27 PM

All times are GMT +1. The time now is 04:47 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us