OT - Excel Macro

For those of you that may have been curious how to do this, thanks to
Linda Lowney, you clear the linked cell. Right click o the drop down
box, select format control, select control and this will display the
linked cell. In your macro just clear this value to clear the drop down
box or set a numeric value to create the default setting. Thanks again
Linda.



Keith





________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Keith Mailloux
Sent: Wednesday, August 16, 2006 8:59 AM
To: vantage@yahoogroups.com
Subject: [Vantage] OT - Excel Macro



I have a pretty elaborate spreadsheet we use for estimating times for
our processes. It utilizes basic data cells, lookups, radio buttons,
check boxes and drop down lists. I have created a "Clear" button which
refreshes the data entry screen and clears any inputs and sets radio
buttons and check boxes to their initial values. I also need to reset
drop down boxes to their initial value but seem to be have a problem
doing so. There does not seem to be anything in the properties box to
set using a macro. Anyone have any experience in this area?

Thanks,

Keith Mailloux

Ferguson Perforating

---------------------------------
This e-mail and any attachments may contain confidential and
privileged information. If you are not the intended recipient,
please notify the sender immediately by return e-mail, delete this
e-mail and destroy any copies. Any dissemination or use of this
information by a person other than the intended recipient is
unauthorized and may be illegal.

[Non-text portions of this message have been removed]





---------------------------------
This e-mail and any attachments may contain confidential and
privileged information. If you are not the intended recipient,
please notify the sender immediately by return e-mail, delete this
e-mail and destroy any copies. Any dissemination or use of this
information by a person other than the intended recipient is
unauthorized and may be illegal.

[Non-text portions of this message have been removed]
I have a pretty elaborate spreadsheet we use for estimating times for
our processes. It utilizes basic data cells, lookups, radio buttons,
check boxes and drop down lists. I have created a "Clear" button which
refreshes the data entry screen and clears any inputs and sets radio
buttons and check boxes to their initial values. I also need to reset
drop down boxes to their initial value but seem to be have a problem
doing so. There does not seem to be anything in the properties box to
set using a macro. Anyone have any experience in this area?



Thanks,



Keith Mailloux

Ferguson Perforating



---------------------------------
This e-mail and any attachments may contain confidential and
privileged information. If you are not the intended recipient,
please notify the sender immediately by return e-mail, delete this
e-mail and destroy any copies. Any dissemination or use of this
information by a person other than the intended recipient is
unauthorized and may be illegal.

[Non-text portions of this message have been removed]