Skip to content
May 9, 2024
MoDCore
Welcome to the core
Primary Menu
360 Degree
Automations
Blue Prism
Blue Prism – Collection to CSV – Custom Delimiter
Faeria
Go Pro Time Lapse
MoDCore Code
Confirmit
Confirmit Apps
Printing from Capi – Page Breaks
Data Processing
Merge string and respid
Horizons
Answer labels into new Variable
Change text function
Check open VS value in dropdown
Clear Form / Page Function
Confirmit array If statement
Count answered questions
Count if question is answered
Custom navigation button labels
Days between 2 dates
Email continue later link to a user
Email to Call block
Emailing Filters
Export File Dynamic Values
Field Length using Java – Confirmit
First character from a string
Force Upper/Lower on open text
Invite links – ^slink^
IP Address and Rendering
Javascript buttons for navigation
Masking
Number of rows for Open text list
Populate Email with variables
Pre Populate Email and Phone
Question Validation Codes
Restrict the text length in a text box
Set field length with java
Set variables on entry and completion
Setting Dates
Small image in survey, click to enlarge
Triggers
Validation Scripts – RegExr
Visual Countdown for open text field length
Reportal
Add Print & date to reportal Page
Change Reportal Label based on Text in Div
Export Reportal
If statement Expression
Table Formula
Fun and Pranks
Mario Theme Song – VBA
Open Internet Explorer Once or Loop – VBA
Randomly Quit Excel – VBA
MS Access – Convert SQL > VBA
MS Excel
MS Excel Formulas
Adding years, months or days to a date
Automate start and end of the month date
Concatenate and Substitute
Data before and after a space
Data Validation Based on Cell Value
Extract Month from a date
Extract Numbers only from a cell
Extract Postcode From Cell
First and Last date of the last month
Named Ranges with Data Validation
Working out SLA Breaches with Excel!
MS Excel Tips
Developer Tab and VBA Starting Point
Excel Conditional Formatting
MS Excel VBA
Button to save sheet as PDF
Clear or Reset Cells on your Form
Connecting to an Oracle Database
Count formulas in a workbook
Dynamically Change Pivot Table Source Data
Input Username and Password in Excel for Oracle DB
Show and hide sheets based on user
Update all Pivots and Graphs – One Button
Upload Text file into Excel – 1 Click
Use Buttons to Navigate Sheets
Webpage Scraper VBA
Windows Username in a Cell
Now TV Box
Now TV Box – Developer Mode
Now TV Box – Stream from your PC
Test Page
VBS
Add desktop shortcut to URL – VBS
Scheduled Job to check for value in excel – send email if found
Visio
Windows 7 – Turn off Task Bar Grouping
MoDCore Warcraft
The Bitcoin Referral Page
Wall of Fame!
Forums
Search for:
Home
MoDCore Code
MS Excel
MS Excel
Microsoft Excel related pages below.
Excel Formulas
Excel Tips
Excel VBA Scripts
You may have missed
1 min read
Core Updates
WordPress – How to Make WordPress Pages Act and Look Like Posts
7 years ago
MoDAdmin
1 min read
Core Updates
So far so good
8 years ago
MoDAdmin
1 min read
Core Updates
All in less than a day
8 years ago
MoDAdmin
1 min read
Uncategorized
Hello world, MoDCore Here!
8 years ago
MoDAdmin