Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old June 17th 20, 10:19 PM
Member
 
First recorded activity by ExcelBanter: Aug 2007
Posts: 80
Default UserForm code help

HELP PLEASE!

I'm struggling with a UserForm "Splash Screen" that will display when macros are processing data in Excel workbook. I already have a UserForm that displays when the macros run, but the UserForm is just a blank screen! I have a picture and label that is visible in the UserForm in VBA but I've struggled to get the correct code that will display the picture and label in Excel when the macros are running.

I have tried numerous codes, read multiple posts and watched several YouTube videos and I'm still not having any success. I know I need UserForm code and macro code to make this function properly.

I have this code:
Sub Macro_runs_macros()

Application.Run _ "'(Workbook name)'!SplashScreen"
Application.Run _ "'(Workbook name)'!(macro 1)"
Application.Run _ "'(Workbook name)'!(macro 2)"
Etc.
Etc.
Unload UserForm1

End Sub


UserForm Code:
Private Sub UserForm_Activate()
Application.Visible = False
Application.OnTime Now + TimeValue("00:01:30"), "Quitform"
Application.Visible = True


End Sub

Macro to call the UserForm:
Sub SplashScreen ()
UserForm1.Show

End Sub


Thank you for your help,
Keyrookie

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Run code from within a UserForm Patrick C. Simonds Excel Programming 2 March 18th 09 06:54 PM
How to get variables from worksheet code to userform code Donny Excel Programming 6 August 23rd 08 01:31 AM
code help w/userform Jennifer Excel Programming 2 May 26th 06 03:47 AM
Userform Code scrabtree23[_3_] Excel Programming 3 December 5th 04 05:05 AM
VBA code for Userform Martin Los Excel Programming 4 December 5th 03 03:04 PM


All times are GMT +1. The time now is 05:36 AM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017