+ Reply to Thread
Results 1 to 2 of 2

Multi worksheet change functions on one page.

  1. #1
    Registered User
    Join Date
    02-16-2016
    Location
    netherlands
    MS-Off Ver
    office 2010
    Posts
    1

    Question Multi worksheet change functions on one page.

    Hy everyone,

    I am fairly new to excel. I started using excel to create a overview on my stock. I wanted to create a table which would allow me ,via drop down menus, to select specifications of products and filter them out of the enormous list of products i have in stock. I figured it would be smart to start of with just 5 items in the table. it would look something like this:

    REG. NR DEVICE NAME DEVICE TYPE CALIBRATED DEPARTMENT USAGE AVAILABLITY LOCATION NOTE
    DS/A/1001 digital simulator YEF-SCE SIM140 no NVT none not-available sold
    DS/A/1002 digital simulator YEF-SCE SIM140 no NVT none not-available sold
    DS/A/1003 digital simulator YEF-SCE SIM140 no NVT none not-available sold
    DS/A/1004 digital simulator YEF-SCE SIM140 yes Service CE Test Available 1A
    DS/A/1005 digital simulator YEF-SCE SIM140-s yes Service CE Test Available 1A modded to distribute 24V (old, dirty)

    REG. NR DEVICE NAME DEVICE TYPE CALIBRATED DEPARTMENT USAGE AVAILABLITY LOCATION
    (drop down menu under every one of these specifications to select the different options)

    lets say i want to see a list of all available products, i want to filter the list via a dorp down menu (right under the avialablity secition, cell G9). i select "available" in the list and it should filter out all the not-available products.
    I figured that this would be achievable via hidding the tabs i need to have filtered out. (by the way, the location doens't point out a cell in excel, A1 is a storage container in real life).

    so with a little bit of help from the internet, i managed to write these lines of code (which work) to achieve this.
    =====================================================
    Please Login or Register  to view this content.
    ===========================================
    that is one specification down. next I need to be able to filter the "calibrated" tab.
    that would be done with the same type of coding. but once I add both of the codes to gether, they stop working.
    ===========================================
    Please Login or Register  to view this content.
    =======================================
    i figured that i could only have one Worksheet_Change(ByVal Target As Range). But i honstly have no idea how to work both codes in to one complet code. I can't figure out any other way of doing this either.
    I have been looking for work arounds but i can't seem to get to one. I decided to go ask for help my self on these forums, i could really use the help of some of the experts on these forums.
    Thanks for your time in advance, i know my english is not really good.. but i am desperate for your help.

    (a attempt of mine to fix the problem)
    ======================================
    Please Login or Register  to view this content.
    =================================
    Last edited by alansidman; 02-16-2016 at 09:14 AM.

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365
    Posts
    19,671

    Re: Multi worksheet change functions on one page.

    Code Tags Added
    Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

    Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

    Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found at http://www.excelforum.com/forum-rule...rum-rules.html



    (Because you are new to the forum, I have added them for you today. Please take a few minutes to read all Forum Rules and comply in the future.)

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. ISSUE: Using the multi selection in list box to change cells in worksheet.
    By mido609 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-17-2013, 08:37 PM
  2. Need help to copy multi page web data into a single worksheet
    By arock08 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-02-2013, 03:07 AM
  3. Change location of commandbuttons on multi page in userform using vba
    By newbi004 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-19-2013, 10:13 AM
  4. [SOLVED] Excel VBA - Dynamically Adding a Page to a Multi-Page UserForm
    By eemiller1997 in forum Excel Programming / VBA / Macros
    Replies: 116
    Last Post: 12-13-2012, 05:26 PM
  5. [SOLVED] Combobox in page 2 of multi page userform excel 2003
    By AliiShariff in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-27-2012, 07:37 PM
  6. [SOLVED] move multi-page Excel worksheet into Word document
    By cedarville in forum Excel General
    Replies: 1
    Last Post: 01-02-2006, 10:10 AM
  7. [SOLVED] change cell size from page to page on the same worksheet
    By Danny in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-15-2005, 03:25 PM
  8. Worksheet Functions that Change Other Cells
    By Robert Mulroney in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-07-2005, 04:20 AM

Tags for this Thread

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