Тёмный

Creating a Splash or Welcome Screen in Excel - Simple Coding 

TheDataLabs
Подписаться 127 тыс.
Просмотров 30 тыс.
50% 1

Creating a Splash or Welcome Screen in Excel
In this video, we will learn how to create a professional Splash Screen or Welcome Screen in Excel with the help of VBA. Here, we will utilize Form Control and Picture to design the form. We will use OnTime method to close the form after seconds.
If you don't know the VBA or Macro then there is no need to worry. This tutorial is a Step by Step guide and with the help of this tutorial, you will be able to develop a profession splash screen and learn several VBA tips and coding.
#SplashScreen #TheDataLabs
Please follow the below link to download the Excel files (automated form ) used in this video.
drive.google.com/file/d/1HwEd...
Please visit our website www.thedatalabs.org
Please contact us on thedatalabs@gmail.com
Thanks for watching!
Please like, share, comment and subscribe.
Have a great day!

Опубликовано:

 

16 ноя 2019

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 25   
@TeenTaalChannel
@TeenTaalChannel 3 года назад
Amazing explanation, thank you, I really appreciate your training here.
@chulakapitigala5147
@chulakapitigala5147 4 года назад
Thanks it's really amazing.
@aas401
@aas401 3 года назад
You Are The Best Thank You
@richardmensah7772
@richardmensah7772 Год назад
Thanks Boss!!
@damientoysinadelaide
@damientoysinadelaide 3 года назад
Works well but not centred on opening, comes up hard left side of sheet. Have played with the Start up positions but no change?
@rohitgurung909
@rohitgurung909 4 года назад
This is awesome....you are a real genius.....can we use this splash screen display on any of our excel file which we use in a daily basis? so that the screen pops up every time when we open that specific file.
@thedatalabs
@thedatalabs 4 года назад
Thanks for your appreciation! Yes, we can use it on some conditional statements.
@denisvitia4362
@denisvitia4362 3 года назад
Pls make a Video ! How to Add Splash Screen in All Projects
@ashhaf63
@ashhaf63 8 месяцев назад
How do you get the Workbook Tab under general?
@tedebear1955
@tedebear1955 4 года назад
PK, how would I incorporate the SPLASH SCREEN in all of my Excel Projects?
@thedatalabs
@thedatalabs 4 года назад
Just add this Spash screen in all projects where you want to add and then make modification in image and then load this form on Workbook Open event. Thanks!
@hugossp
@hugossp 4 года назад
Hi, its not accepting JPG only icons and they are really tiny, do you know how to fix it? Thx!
@SaiKrishna-xb2je
@SaiKrishna-xb2je 4 месяца назад
Facing the same problem
@PiyushMedicalKnowledge
@PiyushMedicalKnowledge 2 года назад
How to disable excel Splash Screen if I don't want another will know that the file is of excel
@ahmadsafiuddinabdrahim9909
@ahmadsafiuddinabdrahim9909 4 года назад
Hi bro, thanks for this. I tried but the splash pic resolution not really good. I mean the jpeg pic was ok. But when i did the form the pic looks very bad after i open the excel file (run macro) how do i improve them ?
@thedatalabs
@thedatalabs 4 года назад
You should use the High resolution image. Also use the image control rather than form background. Hope, it will improve the pic quality.
@ahmadsafiuddinabdrahim9909
@ahmadsafiuddinabdrahim9909 4 года назад
TheDataLabs thanks for your reply. I will try soon. Anyway, keep it up posting and sharing new videos especially on VBA
@sujeetvichare5825
@sujeetvichare5825 4 года назад
@@ahmadsafiuddinabdrahim9909 This picture image is JPG
@sujeetvichare5825
@sujeetvichare5825 4 года назад
Me Thank Me Optical Button
@tayyabatfarms
@tayyabatfarms Год назад
Thanks. How we can hide excel application and show only the form?
@thedatalabs
@thedatalabs Год назад
Thanks! Please watch this tutorial. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-eX4Jar4Gz6w.html
@k.essamkhwaleh9441
@k.essamkhwaleh9441 4 года назад
I do that but the screen not go
@thedatalabs
@thedatalabs 4 года назад
Make aurey you have written the ontime function on form activate.
@k.essamkhwaleh9441
@k.essamkhwaleh9441 4 года назад
thanx a lot ...........done
@s9grstmk62
@s9grstmk62 Год назад
Englisch cant man understand , time for nothing
Далее
EASILY Make an Automated Data Entry Form in Excel
14:52
Excel Splash Screen Macro - Display on Opening a File
15:37
How to Create and Use Excel Macros 😎
13:43
Просмотров 47 тыс.
Digital Rain in an Excel Sheet
8:23
Просмотров 1,7 тыс.
How To Create A Navigation Menu Pane In Excel - No VBA
5:48
Excel UserForm Course 1 - Your First UserForm
13:58
Просмотров 103 тыс.
Excel VBA Calculations in a Userform
14:43
Просмотров 104 тыс.