Pop Up Box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is it possible to set up a pop up box when you open a saved excel document. I
want a reminder to come up for users when they open a mileage spreadsheet I
have designed to prompt them to enter their name. Is this possible? Or is
there another funky way to do it?
Thanking you in advance!
 
Laura

Possible, yes. What do you want to do with the inputted name?

The following places the name in the activecell.

You could hard code a cell like Range("A1").Value = user_name

Private Sub Workbook_Open()
user_name = InputBox("Enter your Name")
ActiveCell.Value = user_name
End Sub

Note: if users disable macros the code will not run.


Gord Dibben Excel MVP
 

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

Similar Threads

pop up box 1
Popping out Message Box! 4
pop up box reminder 2
Prompt user to input data (pop-up box) 2
Dialog Pop Up Box 1
Pop up box 3
pop up box 2
pop up vs. data validation 7

Back
Top