pop up box

E

Emma

Hi, I want a pop up box to appear when the spreadsheet is opened. Is this
possible? Also i would like the information in the pop up box to up issue -
the box would have a number i.e. 3 and if this number is entered then it up
issues to 4 in the pop up box so the next user knows that the number to take
is 4. is this a crazy thing to ask? thanks
 
J

JH

Hi,
You can create 1) a form and 2) an Workbook open event in VBA.
something like:
Userform1.show
as to the number, I assume the numbers are on the worksheet, a textbox or
label etc can be written to read the numbers from the worksheet.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top