pop up box

  • Thread starter Thread starter Emma
  • Start date Start date
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
 
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.
 
Back
Top