LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Display autoshape with circumstances

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.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Enter key does different things in different circumstances Allen Excel Discussion (Misc queries) 0 December 4th 09 05:04 PM
Changing a Macro for new circumstances Paul S Excel Discussion (Misc queries) 0 January 23rd 07 10:48 AM
How to calculate no. of hours under different circumstances. evon Excel Worksheet Functions 3 March 10th 06 04:16 AM
Display AutoShape in UserForm bforster1[_28_] Excel Programming 1 November 3rd 05 02:09 PM
macro in vba to display autoshape jrd269[_6_] Excel Programming 0 June 7th 05 08:45 PM


All times are GMT +1. The time now is 06:11 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"