I have a multi-worksheet workbook that has a first sheet called 'Menu'. There are buttons on this sheet that run various VBA subroutines behind the scenes and I have dedicated a cell on this sheet (G5) to give a message as to what is going on
(I have used the application.screenupdating=false statement)
However, I do not want to disturb the flow of the code by having to constantly select or activate the 'menu' sheet when I want to display a processing message like "Clearing worksheets" etc. then reselecting the worksheet/cell that i was about to work on if you see what i mean.
There must be a way of referencing a cell on another worksheet on passing a 'value' to it
Help!!
(I have used the application.screenupdating=false statement)
However, I do not want to disturb the flow of the code by having to constantly select or activate the 'menu' sheet when I want to display a processing message like "Clearing worksheets" etc. then reselecting the worksheet/cell that i was about to work on if you see what i mean.
There must be a way of referencing a cell on another worksheet on passing a 'value' to it
Help!!