Inputbox

  • Thread starter Thread starter Ewing25
  • Start date Start date
E

Ewing25

How do i get an input box to only come up once when the sheet is open?
 
Right click sheet tab>view code>left window worksheet>right window
activate>put code there
 
Ohhh i gotchya... I did that but i only want it to show up when you click on
the tab the first time, not everytime you click on the tab.
 
Put ALL of this in the sheet module
'==========
Public mycheck

Private Sub Worksheet_Activate()
If mycheck = 1 Then Exit Sub
x = InputBox("enter number here")
MsgBox x
mycheck = 1
End Sub
'=========
 
Thanks! it worked but i found a different way id like to do it. I posted a
question called Simple Autofilter.
 
You must log in or register to reply here.

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

Cancel Input Box error 16
Loop thru xx No. of sheets until the four strValue combo's are found 6
InputBox entries & advice 16
Combine three InputBoxes into one? 7
help with array 5
Somewhat complex code to copy data from one sheet to another 9
inputbox prompt 1
Validation on InputBox() 5

Back
Top