|
|
| |
Download |
Author |
Date |
Description |
Size |
|
|
Jiri Cihar |
26.8.2005 |
Do you think, data validation feature allows you text selection only? Let me convince you are mistaken.
You can donwnload the Excel file with live example extending data validation ability to work with embedded images list. |
845kB/886kB |
|
|
Jiri Cihar |
21.9.2005 |
It might be a good idea to highlight important values with help of conditional formatting. What about a few examples of advanced approach...or not too basic at least.
You can download the Excel file with 3 detailed examples. |
50kB/97kB |
|
|
Jiri Cihar |
27.9.2005 |
Looking for a new and cool chart display?
What about change the range of displayed values just by cursor movement? |
34kB/103kB |
|
|
Jiri Cihar |
27.2.2006 |
Do you develop applications in Excel? Would you like a developing enviroment for menu creation? Pasting your own pictures as button face? Enable or disable default items in main worksheets menu? What about adding combo boxes in your own menu? |
72kB/164kB |
|
|
Jiri Cihar |
15.5.2006 |
How about shape and image animation in Excel? Mission impossible? Download this file and have a look at our aquarium...and then at VBA. |
121kB/160kB |
|
|
Jiri Cihar |
30.5.2006 |
The Advanced Filter enable you to create a more complex selection then AutoFilter based on different criteria in multiple columns.
The workbook contains examples as follows:
- random sampling
-
checking data integrity between original list and working list
-
selecting list of employees belonging to 20% best paid
-
set the list of employees with salary between 85% - 115% of average value
-
identify values missing in list A and occuring in list B
|
130kB/240kB |
|
|
Jiri Cihar |
8.6.2006 |
I am very keen of reading articles at Kathy Sierras web http://headrush.typepad.com . Recently I have found an idea of "Calendar of Life" and was totaly hit and impressed. It was a challenge for me to "wrap" the idea in Excel world. And VBA is 100% at your disposal. |
365kB/484kB |
|
Eng_Aquarium.zip
MenuMaker.pdf