Re: $$Excel-Macros$$ Toggle a Cell value

2011-10-17 Thread Cab Boose
t;> Your request was “when I SELECT the cell”. So, as Sam says, use >>> another event such as doubleclick. >>> >>> Don Guillett >>> SalesAid Software >>> dguille...@gmail.com >>> >>> *From:* Cab Boose >>> *Sent:* Friday

Re: $$Excel-Macros$$ Toggle a Cell value

2011-10-16 Thread Sam Mathai Chacko
ll”. So, as Sam says, use another >> event such as doubleclick. >> >> Don Guillett >> SalesAid Software >> dguille...@gmail.com >> >> *From:* Cab Boose >> *Sent:* Friday, October 14, 2011 8:32 PM >> *To:* excel-macros@googlegroups.co

Re: $$Excel-Macros$$ Toggle a Cell value

2011-10-15 Thread Cab Boose
llett > SalesAid Software > dguille...@gmail.com > > *From:* Cab Boose > *Sent:* Friday, October 14, 2011 8:32 PM > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Toggle a Cell value > > Hi Don and Sam > > Thanks for your input. > > I use

Re: $$Excel-Macros$$ Toggle a Cell value

2011-10-15 Thread dguillett1
Your request was “when I SELECT the cell”. So, as Sam says, use another event such as doubleclick. Don Guillett SalesAid Software dguille...@gmail.com From: Cab Boose Sent: Friday, October 14, 2011 8:32 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Toggle a Cell value Hi

Re: $$Excel-Macros$$ Toggle a Cell value

2011-10-14 Thread Sam Mathai Chacko
gt;> If Target = 1 Then >>> Target = 0 >>> Target.Interior.ColorIndex = 4 >>> Else >>> Target = 1 >>> Target.Interior.ColorIndex = 3 >>> End If >>> End Sub >>> >>> Don Guillett >>> SalesAid Software >&g

Re: $$Excel-Macros$$ Toggle a Cell value

2011-10-14 Thread Cab Boose
xit Sub >> If Target = 1 Then >> Target = 0 >> Target.Interior.ColorIndex = 4 >> Else >> Target = 1 >> Target.Interior.ColorIndex = 3 >> End If >> End Sub >> >> Don Guillett >> SalesAid Software >> dguille...@gmail.com >>

Re: $$Excel-Macros$$ Toggle a Cell value

2011-10-14 Thread Sam Mathai Chacko
arget.Interior.ColorIndex = 4 > Else > Target = 1 > Target.Interior.ColorIndex = 3 > End If > End Sub > > Don Guillett > SalesAid Software > dguille...@gmail.com > > *From:* Cab Boose > *Sent:* Friday, October 14, 2011 2:33 AM > *To:* excel-macros@googlegroups.com > *Subject:* $$Ex

Re: $$Excel-Macros$$ Toggle a Cell value

2011-10-14 Thread dguillett1
rior.ColorIndex = 3 End If End Sub Don Guillett SalesAid Software dguille...@gmail.com From: Cab Boose Sent: Friday, October 14, 2011 2:33 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Toggle a Cell value Hi eveyrone See attached sheet. For a 12 volt motor speed direct

$$Excel-Macros$$ Toggle a Cell value

2011-10-14 Thread Cab Boose
Hi eveyrone See attached sheet. For a 12 volt motor speed direction, Forward or Reverse I want to have a value of a cell to toggle back and forth between 0 and 1 and cell color also to change each time between green and red. Prefer to use a cell than use a toggle button, unless a toggle button