+ Reply to Thread
Results 1 to 4 of 4

Multiple Worksheet Change Events???

  1. #1
    Registered User
    Join Date
    12-28-2005
    Posts
    68

    Red face Multiple Worksheet Change Events???

    Hello,

    Excel 2003 on XP.

    Is it possible to perform more than one change in a Worksheet change event module?

    For example, end users will be copying and pasting from an unformatted source spreadsheet to a template. I would like to ensure that various conditions are imposed on different columns (e.g. forcing CF conditions for maximum characters, Proper case in some, Upper case in others, inserting spaces into some columns based on data entered in another, etc). The reason for this is the number of end users and the huge differences in their exposure to basic Excel functions. The easiest scenario is to allow them all to simply copy and paste from the spreadsheets they receive so that the final data meets the necessary requirements of the template. This template is then used by another application to perform bulk uploads to another system. Provided everything on the template is correct, success of the bulk upload is pretty much guaranteed. If the template is wrong, there is a risk of failure of the action and we are then dependant upon the user recognising the failure and acting on it. (Yes ... I know that's what SHOULD happen ... )

    Or am I asking too much of one module?
    With gratitude,

    Potoroo

  2. #2
    Forum Contributor
    Join Date
    03-13-2005
    Posts
    6,195
    Quote Originally Posted by Potoroo
    Hello,

    Excel 2003 on XP.

    Is it possible to perform more than one change in a Worksheet change event module?

    For example, end users will be copying and pasting from an unformatted source spreadsheet to a template. I would like to ensure that various conditions are imposed on different columns (e.g. forcing CF conditions for maximum characters, Proper case in some, Upper case in others, inserting spaces into some columns based on data entered in another, etc). The reason for this is the number of end users and the huge differences in their exposure to basic Excel functions. The easiest scenario is to allow them all to simply copy and paste from the spreadsheets they receive so that the final data meets the necessary requirements of the template. This template is then used by another application to perform bulk uploads to another system. Provided everything on the template is correct, success of the bulk upload is pretty much guaranteed. If the template is wrong, there is a risk of failure of the action and we are then dependant upon the user recognising the failure and acting on it. (Yes ... I know that's what SHOULD happen ... )

    Or am I asking too much of one module?
    Hi,

    You can perform more than one action, the length of code is not determined by the event, just widen the test to cover the required areas and then check the Target to see which code you should be performing.

    hth
    ---
    Si fractum non sit, noli id reficere.

  3. #3
    Registered User
    Join Date
    12-28-2005
    Posts
    68
    Thank you Bryan.

    This will test me out!

  4. #4
    Forum Contributor
    Join Date
    03-13-2005
    Posts
    6,195
    Quote Originally Posted by Potoroo
    Thank you Bryan.

    This will test me out!
    What are you using to test the Target ?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1