PC Review


Reply
Thread Tools Rate Thread

Display autoshape with circumstances

 
 
zed127@yahoo.com
Guest
Posts: n/a
 
      9th Nov 2006
Hi, new to the group. I do not know anything about VBA and I am hoping
that someone can help me out, I have not found a way to join multiple
formulas to achieve what I am after.

I have cells A1, B1, C1 and 3 different autoshapes
If cell B1 is < A1 I want to return image 1 (green up arrow, autoshape)
in cell C1
If cell B1 is > A1 Iwant to return image 3 (red down arrow, autoshape)
in cell C1
If cell B1 is = A1 I want to return image 2 (yellow left-right arrow,
autoshape) in cell C1

Any ideas or suggestions anyone could offer would be appreciated!

Thanks for your help.

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Tweak to display autoshape Max Microsoft Excel Programming 5 29th Apr 2010 10:00 AM
Draw/Change Autoshape to custom autoshape for a comment Matthew Schwarz Microsoft Excel Discussion 0 11th Oct 2009 06:17 AM
Need control to not display its data under certain circumstances vegathena@gmail.com Microsoft Access Forms 9 25th Jan 2008 10:00 PM
Display AutoShape in UserForm bforster1 Microsoft Excel Programming 1 3rd Nov 2005 02:09 PM
macro in vba to display autoshape jrd269 Microsoft Excel Programming 0 7th Jun 2005 08:45 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 10:07 PM.