Input Box on workbook open

[luke_p]

Hi there,

I have the following code that when the workbook opens input boxes pop up so users enter date and values.

This VBA works great where there is one sheet but now i have 3 sheets (sheet a, b & c) and each sheet will need the same input boxes for user input.

Is it possible for the input boxes to pop up when you click on each sheet separately ?

Any help would be greatly appreciated even if it's an entirely different solution.

Many Thanks

Please Login or Register  to view this content.

[royUK]

In the WorkBook module use the right hand drop down to find SheetActivate. Move your code there with this amendment

Please Login or Register  to view this content.

The code will run for each sheet in the workbook

[luke_p]

Roy thats great.

But, is there a way to stop it once 1 sheet is done, then 2 etc... ?
I ask because a user may go back to the previous sheet but the input boxes come back up again.

The user will only need to see them and enter data once. Its a daily spreadsheet so they open it once save it and then do the same the next day.

[royUK]

The best ay would be to declare a Public Variable. In a standard module type

Please Login or Register  to view this content.

Then check the variable before running the code

Please Login or Register  to view this content.

[luke_p]

Not sure what you mean Roy but i did the following;

And after you type in for 1 sheet and go to the next the boxes don't pop up.

Please Login or Register  to view this content.

as general - Declaration under "thisowrkbook"

Please Login or Register  to view this content.