How would I create a macro that if the value of the cell is positive will paste an object (shape) and if it is negative a different object (shape)<br><br>I guess what I'm looking for is a VBasic statement for if value in this range then ...<br><br>anybody can give me the basics.... <p>Dumboy.! Ouch.! .my brain.....<br><a href=mailto:spiderdesign@yahoo.com>spiderdesign@yahoo.com</a><br><a href= > </a><br>It's hard to think with only one neuron......Ouch.....!....it hurts when I think......!
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Macro code to paste objects...! 3
- Thread starter Dumboy
- Start date
-
3
- #2
How about something like this? I am assuming that you are talking about Excel.<br><br><br>*****************<br><br>'dim a variable for each cell<br>dim c as range<br>'dim a variable for the range to work with<br>dim rngSearch as range<br><br>set rngSearch = YOURRANGE<br><br>for each c in rngSearch<br> if c.value>0 then<br> c.value = ONE OBJECT<br> elseif c.value<0 then<br> c.value = THE OTHER OBJECT<br> end if<br>next c<br><br>***********<br><br>?? What if the value is exactly zero?
- Thread starter
- #3
Kathryn... Thanks.... I think that surely will work....<br><br> <p>Dumboy.! Ouch.! .my brain.....<br><a href=mailto:spiderdesign@yahoo.com>spiderdesign@yahoo.com</a><br><a href= > </a><br>It's hard to think with only one neuron......Ouch.....!....it hurts when I think......!
- Status
Similar threads
- Locked
- Question