ExcelBanter - pop up box

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - pop up box (https://www.excelbanter.com/excel-discussion-misc-queries/249457-pop-up-box.html)

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.

"Emma" wrote:

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