https://www.youtube.com/watch?v=T6MQC5iC6o8 Youtube video how to configure Settings Head in ADE v2.0 ADE On Data Entry Form, find settings and click settings head First, How to change your object or control Four controls We have 4 different objects: TextBox, ComboBox or drop down list, Date Picker and Time Picker. Textbox - In here, you can input … Continue reading Configuration of Settings Head – Automated Data Entry v2.0
Excel Tools
AUTOMATED DATA ENTRY FORM
Automated Data Entry Form Please see my major update in Automated Data Entry v2.0 (August 27, 2020) https://www.excel-crack.com/2020/08/automated-data-entry-v20.html You can watch it here! What's new? (update 9/27/2017) Automated Data Entry Form by Excel-Crack v1.2 Major Update: Protect worksheet from manual editing while working. Minor Updates:Renaming or deleting your data sheet will help you … Continue reading AUTOMATED DATA ENTRY FORM
BETTER THAN VLOOKUP AND INDEXMATCH FUNCTION: MATCHME add-in
(Note: It is not advisable to use this for large amount of rows or data. Instead, use Vlookup or IndexMatch for larger data.) Introducing the upgrade version of Vlookup and IndexMatch Function when it comes to flexibility and looking up data using VBA Macros Add-In customized and defined. It is more likely intelligent and flexible … Continue reading BETTER THAN VLOOKUP AND INDEXMATCH FUNCTION: MATCHME add-in
SpeakToMe: A Speaking Excel – How to set up reminders from Anna (A.I.)
INTRODUCTION Hmmm forgot something? What is it now? Birthdays? I don't know.... How about events? Occasion? Meetings?....... Oh well I don't know, I am too busy person, if I have a secretary or assistant that reminds me when there are up coming events, birthdays, meetings, occasion, etc. etc. Do you have one? Nothing to worry … Continue reading SpeakToMe: A Speaking Excel – How to set up reminders from Anna (A.I.)
SpeakToMe: Speaking Excel – A conversation with Anna using Input Box
INTRODUCTIONA conversation with Anna? Anna as Disney's Frozen? Well no. So who is Anna?Hmmm seems my question didn't correspond by who is Anna. Or maybe I asked What is Anna?Anna is not a human nor an animal, she is a program who was speaking in our last topic ( SpeakToMe: A Talking Excel or Talk to your … Continue reading SpeakToMe: Speaking Excel – A conversation with Anna using Input Box
SpeakToMe: A Speaking Excel
INTRODUCTIONComputer: "Good morning Boss!"User: "How's my system?"Computer: "Good sir! Nothing to report!, how about you, how was your sleep last night?"User: "Yeah, I'm good!, Is my breakfast ready?"Computer: "That's nonsense question sir, I don't even know how to cook. Cook for yourself!"User: "Yeah yeah, I'll cook you later"Talking to your computer? It sounds like crazy … Continue reading SpeakToMe: A Speaking Excel
Talk to your Foolish Computer using Microsoft Excel
"Computer, speak to me. What's the weather condition?. Can I wander around?""Sir, are you blind? it's raining outside you should not go and wander around.""I am not blind, i just don't want look outside and don't say bad thing to me. It's getting on my nerves.""I see sir. you should have programmed me well so … Continue reading Talk to your Foolish Computer using Microsoft Excel
How to Build your own Executable Program using Microsoft Excel VBA (Tic-Tac-Toe) – Mimic
Please Refer to this Post How to make TicTacToe Program Excel VBA Well, I may be honest with you, it's just actually a mimic but it's very useful to impress your friends or even your love ones.We'll just use trick here. So let's see here 1st Do we have a pre-build program? If you don't … Continue reading How to Build your own Executable Program using Microsoft Excel VBA (Tic-Tac-Toe) – Mimic
Excel Crack 