View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
keri keri is offline
external usenet poster
 
Posts: 74
Default Using a variable in more than one sub procedure

Sorry i'm new to Excel and my knowledge is tiny.

I'm guessing you mean to declare the variable where it says Option
Explicit.
Does the gl refer to it being a global variable?

How and where would I put the othere variable to show true/false if it
has been answered already? And once I had this second variable would I
have to refer to it with an If statement,

eg currently my second use of answer says;

For p = 1 to answer

Would it have to be
For p = 1 to answer if bla is true?

How would I word this?