| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Inputbox
How do i get an input box to only come up once when the sheet is open?
|
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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.... |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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.... |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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.... |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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.... |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| InputBox | Excel Discussion (Misc queries) | |||
| Need InputBox Help | Excel Programming | |||
| inputbox | Excel Discussion (Misc queries) | |||
| Using the value in the inputbox again | Excel Programming | |||
| Inputbox and Application.InputBox | Excel Programming | |||
Linear Mode
