Macro to automatically open a website or send an e-mail in excel

How might I create a macro that detects when a field is changed from one
status to another and automatically either creates a popup to a webaddress or
sends an e-mail?

For example: In the Status field, You can select yes, no or maybe. If the
value is changed from yes to no, I would like macro to automatically detect
this and create a questionnaire e-mail or to link to a website.
Any help would be greatly apppreciated.

Try this
http://www.rondebruin.nl/mail/change.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Byron" <[email protected]> wrote in message news:[email protected]...
> How might I create a macro that detects when a field is changed from one
> status to another and automatically either creates a popup to a webaddress or
> sends an e-mail?
>
> For example: In the Status field, You can select yes, no or maybe. If the
> value is changed from yes to no, I would like macro to automatically detect
> this and create a questionnaire e-mail or to link to a website.
> Any help would be greatly apppreciated.

Hi Ron,

Thank you for the suggestion, I'm still playing around with it as I have
very little experience with Excel macros. I was wondering if it is possible
to automatically open a internet explorer browser with a preset webaddress
instead?

Also, do you know if you can run macros from an excel uploaded into a
sharepoint site?
Thanks,

-Byron

"Ron de Bruin" wrote:

> Try this
> http://www.rondebruin.nl/mail/change.htm
>
>
> --
> Regards Ron de Bruin
> http://www.rondebruin.nl
>
>
> "Byron" <[email protected]> wrote in message news:[email protected]...
> > How might I create a macro that detects when a field is changed from one
> > status to another and automatically either creates a popup to a webaddress or
> > sends an e-mail?
> >
> > For example: In the Status field, You can select yes, no or maybe. If the
> > value is changed from yes to no, I would like macro to automatically detect
> > this and create a questionnaire e-mail or to link to a website.
> > Any help would be greatly apppreciated.
>
>
>

Use this
ActiveWorkbook.FollowHyperlink Address:="http://www.rondebruin.nl/Google.htm"


> Also, do you know if you can run macros from an excel uploaded into a
> sharepoint site?

No


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Byron" <[email protected]> wrote in message news:[email protected]...
> Hi Ron,
>
> Thank you for the suggestion, I'm still playing around with it as I have
> very little experience with Excel macros. I was wondering if it is possible
> to automatically open a internet explorer browser with a preset webaddress
> instead?
>
> Also, do you know if you can run macros from an excel uploaded into a
> sharepoint site?
> Thanks,
>
> -Byron
>
> "Ron de Bruin" wrote:
>
>> Try this
>> http://www.rondebruin.nl/mail/change.htm
>>
>>
>> --
>> Regards Ron de Bruin
>> http://www.rondebruin.nl
>>
>>
>> "Byron" <[email protected]> wrote in message news:[email protected]...
>> > How might I create a macro that detects when a field is changed from one
>> > status to another and automatically either creates a popup to a webaddress or
>> > sends an e-mail?
>> >
>> > For example: In the Status field, You can select yes, no or maybe. If the
>> > value is changed from yes to no, I would like macro to automatically detect
>> > this and create a questionnaire e-mail or to link to a website.
>> > Any help would be greatly apppreciated.
>>
>>
>>