$$Excel-Macros$$ Being informed when a user changes sheet

2011-10-25 Thread Chris Boxall
hange sheet within my macro's workbook. However, it does not get executed when the user changes sheet within his workbook. What am I missing? Is there any documentation on this that you can point me to please? Ch

$$Excel-Macros$$ Selecting contents of a control

2011-10-25 Thread Chris Boxall
whole contents so the user can provide completely new input easily. Chris Boxall -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join

$$Excel-Macros$$ Please read and adhere to these Simple Rules

2011-03-02 Thread Chris Boxall
(or at least better English for non-native English speakers) will always encourage more respect. Chris Boxall *General suggestions:* 1. Don't put your email address in a post unless you're dying for more spam in your inbox. 2. Don't eve

$$Excel-Macros$$ Analysing VBA code

2011-01-18 Thread Chris Boxall
does not seem to provide such a utility. Can you tell me if such utilities are available and how I could obtain them? Chris Boxall -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks

RE: $$Excel-Macros$$ Obtaining system information

2010-12-15 Thread Chris Boxall
Daniel, Excellent. Thank you very much. Both of these work exactly as I wished. I have now located ENVIRON in the VBA-Help. I see that I can use this to read other environment variables as shown in ControlPanel>System>Advanced>EnvironmentVariables. However, COMPUTER-NAME and USER-NAME are not