onchange

Hello, I've got this onchange bit of code I'm working on and its basically a simple index match unfortunately, it doesn't work as 'subscription is out of range' Couldn't anyone tell me where I'm going wrong? TIA Private Sub Worksheet_Change(ByVal Target As Range) Dim WorkRng As Range Dim...

For some reason, all code (i.e., onchange, worksheet_activate, worksheet_deactivate) behind my tabs are not executing automatically. I know that they run, bc, I can step in them to execute them. Also all of my other code runs as expected. Could there actually be a setting that is preventing...

Good Morning Everyone I am trying to make a dynamically created CheckBox show a UserForm OnChange. I am using a Class module for this, but I keep getting the "object required" error... Is this something you can help me out with? (pardon this wall of code) The class I'm using looks like this...

Is there anybody here who is familiar with AJAX code through the web browser and VBA coding? I have a webpage in which there is a pull-down menu for "Request Type." When you pull-down and select an entry from the first pull-down menu, this triggers code to show the second pull-down menu. When...

Hi, Im trying to implement SubTotal for my tree structure. I have validation list with values: H1, H2, H3, H4. Example: when user select H2, SubTotal should sum each value from H2 to H4 level. When select H3, SubTotal should sum each value from H3 to H4 level. Please see below example...

Hello all.. first off, confession: I'm a newbie to VBA and to MrExcel. That said, I'm working on a workbook for a horse club. My sheet 1 is "MeetSetupSettings" - info/settings about today's competition. My table lists today's events (A5:A11) and divisions chosen for each event (B5:D11).. all...

I have a report template which contains a combobox which has a ListFillRange which is a Named Range. The combobox has a OnChange macro which kicks in when the end user selects an option from the combobox. The problem I have is every month the report changes & I have to refresh the values in the...