Mrrrr's Forum (VIEW ONLY)
Un forum care ofera solutii pentru unele probleme legate in general de PC. Pe langa solutii, aici puteti gasi si alte lucruri interesante // A forum that offers solutions to some PC related issues. Besides these, here you can find more interesting stuff.
|
Lista Forumurilor Pe Tematici
|
Mrrrr's Forum (VIEW ONLY) | Reguli | Inregistrare | Login
POZE MRRRR'S FORUM (VIEW ONLY)
Nu sunteti logat.
|
Nou pe simpatie:
runnyroxy pe Simpatie.ro
 | Femeie
24 ani
Suceava
cauta Barbat
26 - 57 ani |
|
Mrrrr
AdMiN
 Inregistrat: acum 17 ani
Postari: 2228
|
|
Lots of word tips and customization solutions:
Modify QAT icons in Microsoft Word:
Customize the Office Ribbon
and many more...
**************
Excel customization tips and solutions:
Excel ribbon macros tab:
Add Custom Ribbon Tab to Excel Workbook
Add Your Own Icon to an Excel Custom Ribbon Tab
***************
Customize the images in the QAT
_______________________________________
|
|
| pus acum 6 ani |
|
|
TRaP
Moderator
Inregistrat: acum 6 ani
Postari: 787
|
|
Make add-in with permanent ribbon modifications (in all files)
Change the Ribbon in Excel 2007-2016 also in here:
Menu for favorite macros in Quick Access Toolbar in Excel 2007-2016
Load different RibbonX when opening file in Excel 2007 or 2010/2016
Dynamic Menu for your favorite macros in Excel 2007-2016
|
|
| pus acum 6 ani |
|
|
TRaP
Moderator
Inregistrat: acum 6 ani
Postari: 787
|
|
Compare Sheets or Workbooks in Excel:
Spreadsheet Compare - ONLY AVAILABLE IN OFFICE PROFESSIONAL PLUS
Download Spreadsheet Compare Setup - WORKING FOR EXCEL 2000 OR LATER
********************
8 Excel Add-ins to Make Visual Spreadsheets
50 Best Excel Add-ins
Modificat de TRaP (acum 6 ani)
|
|
| pus acum 6 ani |
|
|
TRaP
Moderator
Inregistrat: acum 6 ani
Postari: 787
|
|
imageMSO list - icons and codes:
|
|
| pus acum 6 ani |
|
Mrrrr
AdMiN
Inregistrat: acum 17 ani
Postari: 2228
|
|
VBA Code Snippets - Most useful:
Tutorials
_______________________________________
|
|
| pus acum 6 ani |
|
Mrrrr
AdMiN
Inregistrat: acum 17 ani
Postari: 2228
|
|
Excel VBA & AutoFilter AutoFilter provides us with a MUCH faster alternative to loops of all kinds
Excel VBA AutoFilter Criteria How to add the criteria for AutoFilter in VBA.
Excel VBA AutoFilter Dates Using dates in AutoFilter can be tricky if not using the US date format.
Create Worksheets for Each Item in an Excel Table of Data I'm often asked how one could create x number of Worksheets where each one houses the data specific to each item in a table. The task at hand is to create 1 Worksheet for each item (named as the item) and have all associated data on it.
_______________________________________
|
|
| pus acum 6 ani |
|
|
TRaP
Moderator
Inregistrat: acum 6 ani
Postari: 787
|
|
Create scroll-able area in sheet:
|
|
| pus acum 6 ani |
|
|
TRaP
Moderator
Inregistrat: acum 6 ani
Postari: 787
|
|
RGB tables with codes, color picker, HTML/CSS, HEX codes and more:
Word Enumerations lists (wd)
|
|
| pus acum 6 ani |
|
|
TRaP
Moderator
Inregistrat: acum 6 ani
Postari: 787
|
|
Powerpoint Add-ins:
Modificat de TRaP (acum 5 ani)
|
|
| pus acum 5 ani |
|
|
TRaP
Moderator
Inregistrat: acum 6 ani
Postari: 787
|
|
XML Hacking: Locking Graphics
XML Hacking: An Introduction
|
|
| pus acum 5 ani |
|
|
TRaP
Moderator
Inregistrat: acum 6 ani
Postari: 787
|
|
Outlook Add-in to Close Outlook to Taskbar
Outlook Save Attachments From Multiple Emails At Once [VBA]
|
|
| pus acum 5 ani |
|
|
TRaP
Moderator
Inregistrat: acum 6 ani
Postari: 787
|
|
Charts - how to better show your data:
- sparklines
- in-cell arrows
- using tables
- sunburst charts - much better than a pie
- waterfall charts
- doughnuts
- project tracking gantt chart
- show goal on thermometer chart
- charts that change as you enter data
- charts that change with drop down list selection
Modificat de TRaP (acum 5 ani)
|
|
| pus acum 5 ani |
|
|
TRaP
Moderator
Inregistrat: acum 6 ani
Postari: 787
|
|
More charts and data analysis tips and tricks:
|
|
| pus acum 5 ani |
|
Mrrrr
AdMiN
Inregistrat: acum 17 ani
Postari: 2228
|
|
VBA Code Examples
Basics
Guide to Loops - Fors, Dos and More
If, If-Else, And, Or
Select Case
Cut, Copy, Paste from a Macro
Save File - 20 Easy Examples
Ranges and Cells
Get / Set Cell Values
Select Range
Offset Range or Cell
Select All Cells
Get the active cell's Column
Change Cell Font Properties
Clear Cells
Test if Selection is Range
Merge Cells
Bold Text in a Cell
Wrap Text
Range Address
Finding the Maximum Value in Each Column in a Range
Delete All Named Ranges
Highlight Duplicates in a Range
Join Multiple Ranges
Remove Formatting For Each Cell In Range
Size an Object to a Range Size
Change a Cells Background Color
Return Column Letter of Cell
Determine Start and End Column of a Merged Cell
Macro to Autofill
Sum by Color
Rows & Columns
Delete Rows that Meet Certain Criteria in VBA
Selecting Every 5th Row
Remove Blank Rows
Row Height - Column Width
Count the rows in a Selection
Count the Number of Used Rows
Autofit Columns
Select Non Contiguous Columns
Sheets
Ultimate Guide to Worksheets
Activate, Select Sheet and Working with ActiveSheet
Add / Insert Worksheet
Copy Worksheet
Hide / Unhide Worksheets
Delete or Clear Worksheet
Get Sheet Name / Rename Sheet
Unprotect / Protect Worksheets
Macro to List all Sheets in a Workbook
Count the sheets in a Workbook
Hide WorkSheet Tabs
Unhide All Worksheets
Clear Entire Sheet
Macro to Create a Hyperlink Menu of Worksheets
Macro to Update all Worksheets in Workbook
Set the Default Sheet When a WorkBook Opens
Workbooks
Create New Workbook
Open / Close Workbook
Merge Workbooks
Files
List of all files contained within a Directory
List Files in Folder
Export Range to Delimited Text File
Delete files from the hard drive
Convert Excel to CSV (Comma Delimited Text File)
VBA - Test if Workbook is Open by Workbook Name
Validate Filenames
File Exists
Copy File
Delete File
Rename File
Open File Dialog
Text and Strings
Text Strings and Substrings Functions
Extract Number From String
Find the nth Word in a String
Concatenate Text(&)
New Line / Carriage Return
VBA and Vlookup: Find occurence of string
VBA Function To Calculate Number of Words in a String
Subroutine to Reverse a String
Remove Characters from Left or Right Side of Variable Length String
Loop Through a String
Add Spaces to a String - Space()
Find Text in a String (instr)
Force Proper, Upper, or Lower case automatically
Char / Chr Function
Upper, Lower, and Proper Case - Case Functions
Prevent VBA Case Sensitive
Like Operator
Logical Operators
Comparison Operators - Not Equal To and More
Compare Strings (StrComp)
Convert Text to Number
Convert Number to Text
VBA Coding Concepts
Guide to Debug.Print & Immediate Window
Code Formatter Add-in
Online VBA Code Indenter
GoTo Line Label
Run a Macro Line by Line
Excel Named Ranges and Programming
Run a Macro from a Macro
Language References
Modify the right-click menu to call a macro
Benchmarking Code
VBA - Wait, Delay, Create a Timer While Running Code
Commenting
On Error Exit Sub
Option Explicit
DoEvents
Exit Sub Or Function
End All Code Execution
Events
Run Macro on Excel Open
Show or load a form when Excel starts
Run a macro when Excel closes
Run a Macro When a Cell Changes
Force a Workbook to Save
Exit Without Saving
Loops
For Each Loop Examples
Exit Loop
Exit For
Settings
Turn off Screen Updating
Turn Off - Turn On Calculation
Calculate Now
Status Bar Updating
VBA Turn Scroll Bars On or Off
Turn On Formula Bar - Turn Off Formula Bar
Prevent warning messages from a macro
In Depth Tutorials (Updating Soon)
Array Examples
Loop Through a Range
Formatting
Format Painter
Excel's Colour Scheme
Shapes, Charts, and Objects
Guide to Charts and Graphs
Guide to Pivot Tables
Guide to Objects
Delete All Autoshapes
How to Create a Bar Chart using VBA
Tables and ListObjects
AutoFilters
UserForms & Controls
Open / Close UserForm
ListBox
ComboBox
CheckBox
Spin Button
Option Button
Misc.
Hyperlinks
Delete Hyperlinks
Add or Remove Cell Comments from a Macro
Random Numbers
Check Spelling
Turn Off Autofilter From Code
Code or Program a Data Validation List
User Interaction
Yes or No Message Box
Input from a User in a Macro (InputBox)
Line Break or Line Feed in a Message Box
View
Zoom - Fit Selection
Zoom...Zoom
WorkBook Events Don't save with Freeze Panes
Scroll Vertically and Scroll Horizontally
Page Break Preview
Display Fullscreen
Hide Excel (The Entire Application)
ActiveWindow.WindowState
Variables
Data Types - Variables and Constants
Range Variables
Global Variables
Public Variables - Use in Multiple Modules or Subs
Array Variables
Date Variable
Declare Variables - Dim
Constant Expression Required
Internet
Launch Internet Explorer from VBA
Advanced Programming
Advanced VBA Examples
Timer Function
SendKeys
Guide to RegEx
Functions
Date Functions
Check if Sheet and/or Range Exists
UDF to perform a 3-parameter Vlookup
Compare Dates
Isnumber / Isnumeric
IsEmpty / IsBlank
Round, RoundUp, RoundDown
Macro Basics
Record a Macro
Editing Macros
Run a Macro
Add a button and Assign a Macro
Macros Disabled? How to Enable Macros
_______________________________________
|
|
| pus acum 5 ani |
|
|
TRaP
Moderator
Inregistrat: acum 6 ani
Postari: 787
|
|
Interesting add-on with functions to Excel:
LITlib adds over 100 functions to Excel. If you are a Visual Basic programmer you will find a lot of the standard Visual Basic functions that are normally not available in Excel like DateAdd, DateDiff, FileLen, Format and many more. A lot more other functions have been added too. Functions to access drive details (drive letter, drive type, free space), as well as information about attributes etc. Have a look at it, you won’t be disapointed.
|
|
| pus acum 5 ani |
|
Mrrrr
AdMiN
Inregistrat: acum 17 ani
Postari: 2228
|
|
VBA for smarties
This website is dedicated to the use of Visual Basic for Applications (VBA).
VBA is the programming language of Microsoft's Office and all other software that makes use of it.
VBA has therefore a large amount of 'libraries'.
Every library contains methods that are specifically suited for each program.
There's also a specific VBA library,that contains methods that can be used by every VBA-fit program.
VBA offers opportunities to communicate between software: from one program you can give instructions to another using VBA.
Task integration is a VBA benefit that can't be achieved using the User Interface.
The code you will find in these pages comprises the minimal code to perform a certain task.
It may be necessary or practical to add some testing code for specific situations; I'll leave that to every coder to decide.
To restrict the code presented here to the absolute necessary minimum keeps the pages simple to read and the code easy to use.
Unless absolutely required to run the code properly variables won't be declared in the code examples. That's left to the user's discretion.
All green formatted code is meant to be adapted to the user's situation(e.g. foldernames, filenames, Driveletter, subject, etc.).
Basically a code-snippet acts as a complete macro, provided the necessary adaptation to the user's environment.
The presented code can be part of a macromodule, sheetmodule, workbookmodule or userform module unless indicated otherwise.
Every page contains a 'red button': suggestions.
If you spot typos, style errors, grammar violations or reasoning deficiencies please report those in order to have them amended/restored.
If you worked out a more elegant solution: your code is very welcome.
Your contributions on the structure of these webpages, the layout and userfriendliness are highly appreciated.
Signals on what is missing in your opinion will be seriously taken into account. |
_______________________________________
|
|
| pus acum 5 ani |
|
|
TRaP
Moderator
Inregistrat: acum 6 ani
Postari: 787
|
|
VBScript Scripting Techniques
|
|
| pus acum 5 ani |
|
Mrrrr
AdMiN
Inregistrat: acum 17 ani
Postari: 2228
|
|
Windows Registry for Advanced Users
_______________________________________
|
|
| pus acum 4 ani |
|
Mrrrr
AdMiN
Inregistrat: acum 17 ani
Postari: 2228
|
|
VBScript useful scripts:
Categories:
Active Directory
Applications
Computer Management
Desktop
Disk and File Systems
Enterprise Scripts
Files and Folders
Group Policy
Hardware
IIS
Logs
Messaging and Communication
Microsoft Office
Monitoring
Networking
Operating System
Other Directory Services
Printing
Processes
Registry
Scripting Techniques
Security
Service Packs
Services
Services for UNIX
Shadow Copy
Software Update Services
Storage
Task Scheduling
Terminal Services
Users and Groups
Virtual Server
More:
-------------------------------------
Few scripts, useful
-------------------------------------
Few scripts, fun, pranks
-------------------------------------
Ultimate VBS tutorial
-------------------------------------
_______________________________________
|
|
| pus acum 4 ani |
|
|
TRaP
Moderator
Inregistrat: acum 6 ani
Postari: 787
|
|
How to Use Conditional Formatting in Excel: 15 Awesome Tricks
|
|
| pus acum 4 ani |
|
|
TRaP
Moderator
Inregistrat: acum 6 ani
Postari: 787
|
|
VBA for PowerPoint:
Various tutorials for Office, Excel, PowerPoint and Word:
Office related apps / add-ins:
|
|
| pus acum 3 ani |
|
Mrrrr
AdMiN
Inregistrat: acum 17 ani
Postari: 2228
|
|
Pivot formatting solutions:
Function toggle
Slicer selection in formulas:
Chart formatting tips and shortcuts
_______________________________________
|
|
| pus acum 1 an |
|
Mrrrr
AdMiN
Inregistrat: acum 17 ani
Postari: 2228
|
|
Office Scripts - the new language under office that works in online (eg. sharepoint) files:
_______________________________________
|
|
| pus acum 8 luni |
|