Date and Time
 

Hi,

I am new to Excel VBA. I have created a user form (My Main Form). Also
there are other sub forms that are invoked from the main form. In each
form, in addition to the different controls, I also want to display
date and time.

Q1. Whatever I may be doing on a form, I want the time (clock)
constantly ticking, i.e., the time should update every second on the
form. Also I want to display the date in the same fashion. This should
be done in all the forms. Is this possible?

Q2. Is it possible to not to show the excel sheet(s) at the background
while I am running my VBA code?

Q3. Is it possible to specify a particular sub-routine to start
everytime we run the application.

Q4. Also can someone suggest me some good VBA coding techniques,
tricks and examples?

Thanks in advance.
Prasad Vanka