Generate a pop-up

A

Alex

Hello

I am pretty familiar with Excel and know a bit about VBA.

What I want to do is the following. In Excel I have a list of words and
their meanings, just like a dictionary. In order to help remember them, each
time I switch on my computer I want a pop-up to launch entitled 'Word Of The
Day' for example. In the pop-up would be one of my words from the database
and its meanings.

My Excel sheet is very simple and I can see ways of getting a pop-up and
asking VBA to pick a word from cells A1:A100 at random. So each day the word
I would see would be random.

The question is, how do I get the pop-up to launch once I turn on my
computer. Is that possible via VBA? If not, can it be done each time I launch
Excel (which I do every day). For example, I open the same Excel spreadsheet
every day. Could I tie my VBA code to that sheet such that when it opens I
get my pop-up too.

Kudos to any guy or gal who knows a way to do this.

As always on this forum, I appreciate any feedback.

Regards


Alex
 
F

Frank Kabel

Hi
do you want this then your PC starts or then you start Excel. For the
first part I would not use VBA / Excel at all
 
A

Alex

Frank

Ideally I would want it when I start my PC.

If not, then when i start Excel would be fine. I say this because I open the
same Excel sheet every day and i thought if I could use VBA it would make
things easier.

What do you suggest Frank?

Regards

Alex
 
Top