Inputbox
 

How do i get an input box to only come up once when the sheet is open?

Inputbox
 

Right click sheet tabview codeleft window worksheetright window
activateput code there

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Ewing25" wrote in message
...
How do i get an input box to only come up once when the sheet is open?

Inputbox
 

What do you mean left window activate, right window activate?

"Don Guillett" wrote:

Right click sheet tabview codeleft window worksheetright window
activateput code there

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Ewing25" wrote in message
...
How do i get an input box to only come up once when the sheet is open?

Inputbox
 

"Don Guillett" wrote in message
...

Right click sheet tabview codeleft window worksheetright window
activateput code there

It might be a little easier for new people to follow if you said "left/right
dropdown" instead of "window". I'm an experienced programmer and it took me
a few seconds to figure out what you were saying....

Inputbox
 

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.



"Jeff Johnson" wrote:

"Don Guillett" wrote in message
...

Right click sheet tabview codeleft window worksheetright window
activateput code there

It might be a little easier for new people to follow if you said "left/right
dropdown" instead of "window". I'm an experienced programmer and it took me
a few seconds to figure out what you were saying....

Inputbox
 

I've noticed that programmers have that problem.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Jeff Johnson" wrote in message
news:mfmdnVOA_5I7i4bVnZ2dnUVZ_u6dnZ2d@datapex...
"Don Guillett" wrote in message
...

Right click sheet tabview codeleft window worksheetright window
activateput code there

It might be a little easier for new people to follow if you said
"left/right dropdown" instead of "window". I'm an experienced programmer
and it took me a few seconds to figure out what you were saying....

Inputbox
 

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
'=========
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Ewing25" wrote in message
...
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.



"Jeff Johnson" wrote:

"Don Guillett" wrote in message
...

Right click sheet tabview codeleft window worksheetright window
activateput code there

It might be a little easier for new people to follow if you said
"left/right
dropdown" instead of "window". I'm an experienced programmer and it took
me
a few seconds to figure out what you were saying....

Inputbox
 

Thanks! it worked but i found a different way id like to do it. I posted a
question called Simple Autofilter.

"Ewing25" wrote:

How do i get an input box to only come up once when the sheet is open?