LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Toggling Visibility of items with VBA


Hello,

New to this forum. Created my own invoice for my business and I am
trying to toggle an image that will appear based on the fact of the
invoice being an invoice or a packing list. (You know how they cover
the price and cost columns of a packing list you'd receive when you buy
something.)

In one cell, it will actually say "INVOICE" or "PACKING LIST". I would
like the filled rectangles to be toggled based on those specific words.

I can't seem to be able to make any kind of formula to check that and
make it invisible.

Does anyone know a simple way to do that?

Thanks in advance for any help.

Mike


--
SpielbergRules
------------------------------------------------------------------------
SpielbergRules's Profile: http://www.excelforum.com/member.php...o&userid=35981
View this thread: http://www.excelforum.com/showthread...hreadid=557674

 
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
OLAP Pivot table - How to show items with no data ? Timmo Excel Worksheet Functions 1 March 30th 06 06:03 PM
Lookup items and have picture appear together. WL Excel Worksheet Functions 6 March 14th 06 03:32 PM
Pareto's Law and ABCD ranking of items nander Excel Discussion (Misc queries) 2 February 19th 06 07:47 PM
multiple items in database Peter Excel Worksheet Functions 2 June 15th 05 08:19 PM
Can't group pivot table items by month in Excel scott_ensley Excel Discussion (Misc queries) 1 February 1st 05 08:41 PM


All times are GMT +1. The time now is 01:18 AM.

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

About Us

"It's about Microsoft Excel"