Biff,

I'm trying to add an ActiveX control Text Box to a sheet form in Excel 2007.
I can add the ActiveX Text Box control from the Developer menu "Insert" set
of ActiveX choices, and then I can go into properties and set the "Linked"
property to a particular cell in the spreadsheet. This works dandy, as when
I type anything in the "Data," "Text" property within the properties setup, I
see the text populating into the Linked Cell I designated. What has me
totally stumped is that once I close the properties box and go back to the
sheet form, I cannot--as a user--type anything into the text box. Every time
I click on it, the ActiveX box simply behaves as though it is an object. The
point of my putting the text box there is so that users of the form can enter
text for "Other" conditions which canot be captured by other questions on the
form.

How do I get this ActiveX control Text Box to allow Input by the user typing
directly into it? For now, the ActiveX text box seems to be behaving as a
text box formatted for "display only," such as the "Home Phone" text box
label that might be situated next to another text box into which the user CAN
type their home phone number. I need to be able to format this ActiveX text
box so that the user CAN type into it.

Help!

Thanks,

Karen

"T. Valko" wrote:

Select cell C3

Goto Home tabStylesConditional FormattingManage Rules

Click New RuleUse a formula to determine...
Format values where this formula is true:
=AND(COUNT(A1,B1,C3)=3,C3<A1+B1)
Click the Format button
Select the desired style(s)
OKOK
Click New Rule again and repeat the above proccess for the second
condition. Use this formula:
=AND(COUNT(A1,B1,C3)=3,C3=A1+B1)

Then, OKOKApplyOK


--
Biff
Microsoft Excel MVP


"KMorris" wrote in message
...
Christine<

In Excell 2007, I want to be able to set a formula for a single cell (c3)
such that it turns red when its numerical contents are =not(a1+b1 = c3)
and
the cell turns green when its numerical contents =(a1+b1=c3). How do I
set
both of these condiions for a single cell in Excel 2007?

Thanks,

Karen

"SteveG" wrote:


Christine,

Yes. In A1 go to Conditional Formatting. Change the Cell Value is
option to Formula is. Enter

=B1="Your Text"

Click Format, Font select the color you want. Click OK, OK.

HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile:
http://www.excelforum.com/member.php...fo&userid=7571
View this thread:
http://www.excelforum.com/showthread...hreadid=570036